I have about 9 seperate workbooks. Within each there are about 4-5 different
worksheets. I would like to combine all of these into one workbook. So I'm
looking to create a master workbook with sub-categories of 9 workbooks,
within each 4-5 different pages. Is this possible?

Do the individual worksheets within each workbook contain links to other
worksheets/workbooks? Or is each worksheet self-contained? If each
worksheet is self-contained I suppose you could just copy and paste the data
into the new workbook.

If the worksheets are not self-contained, something like this may help:
http://www.office-addins.com/-excel-...assistant.html

Dave

--
Brevity is the soul of wit.


"banjoread" wrote:

I have about 9 seperate workbooks. Within each there are about 4-5 different
worksheets. I would like to combine all of these into one workbook. So I'm
looking to create a master workbook with sub-categories of 9 workbooks,
within each 4-5 different pages. Is this possible?

The worksheets are self contained, no links. What I'm trying to do though
is basically create two layers of tabs at the bottom of the workbook. RIght
now there are tabs for individual worksheets. Ideally, I'd like one
workbook. At the bottom there would be a tab for each of the individual 9
workbooks that I have now. Then whithin that workbook tab, you'd find the
normal tabs for the seperate worksheets. So instead of having 9 seperate
workbooks, I'd have just one, but within that one there would be 9 different
groups. Within each group there'd be 4-5 different pages. Does this make
sense? Thanks so much for your help!

"Dave F" wrote:

Do the individual worksheets within each workbook contain links to other
worksheets/workbooks? Or is each worksheet self-contained? If each
worksheet is self-contained I suppose you could just copy and paste the data
into the new workbook.

If the worksheets are not self-contained, something like this may help:
http://www.office-addins.com/-excel-...assistant.html

Dave

--
Brevity is the soul of wit.


"banjoread" wrote:

I have about 9 seperate workbooks. Within each there are about 4-5 different
worksheets. I would like to combine all of these into one workbook. So I'm
looking to create a master workbook with sub-categories of 9 workbooks,
within each 4-5 different pages. Is this possible?

You can't create two layers of tabs....
--
Brevity is the soul of wit.


"banjoread" wrote:

The worksheets are self contained, no links. What I'm trying to do though
is basically create two layers of tabs at the bottom of the workbook. RIght
now there are tabs for individual worksheets. Ideally, I'd like one
workbook. At the bottom there would be a tab for each of the individual 9
workbooks that I have now. Then whithin that workbook tab, you'd find the
normal tabs for the seperate worksheets. So instead of having 9 seperate
workbooks, I'd have just one, but within that one there would be 9 different
groups. Within each group there'd be 4-5 different pages. Does this make
sense? Thanks so much for your help!

"Dave F" wrote:

Do the individual worksheets within each workbook contain links to other
worksheets/workbooks? Or is each worksheet self-contained? If each
worksheet is self-contained I suppose you could just copy and paste the data
into the new workbook.

If the worksheets are not self-contained, something like this may help:
http://www.office-addins.com/-excel-...assistant.html

Dave

--
Brevity is the soul of wit.


"banjoread" wrote:

I have about 9 seperate workbooks. Within each there are about 4-5 different
worksheets. I would like to combine all of these into one workbook. So I'm
looking to create a master workbook with sub-categories of 9 workbooks,
within each 4-5 different pages. Is this possible?

bummer. Thanks!

"Dave F" wrote:

You can't create two layers of tabs....
--
Brevity is the soul of wit.


"banjoread" wrote:

The worksheets are self contained, no links. What I'm trying to do though
is basically create two layers of tabs at the bottom of the workbook. RIght
now there are tabs for individual worksheets. Ideally, I'd like one
workbook. At the bottom there would be a tab for each of the individual 9
workbooks that I have now. Then whithin that workbook tab, you'd find the
normal tabs for the seperate worksheets. So instead of having 9 seperate
workbooks, I'd have just one, but within that one there would be 9 different
groups. Within each group there'd be 4-5 different pages. Does this make
sense? Thanks so much for your help!

"Dave F" wrote:

Do the individual worksheets within each workbook contain links to other
worksheets/workbooks? Or is each worksheet self-contained? If each
worksheet is self-contained I suppose you could just copy and paste the data
into the new workbook.

If the worksheets are not self-contained, something like this may help:
http://www.office-addins.com/-excel-...assistant.html

Dave

--
Brevity is the soul of wit.


"banjoread" wrote:

I have about 9 seperate workbooks. Within each there are about 4-5 different
worksheets. I would like to combine all of these into one workbook. So I'm
looking to create a master workbook with sub-categories of 9 workbooks,
within each 4-5 different pages. Is this possible?