Combining Workbooks

[Guest]

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?

 

[Guest]

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-addins/consolidation-assistant.html

Dave

 

[Guest]

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!

 

[Guest]

You can't create two layers of tabs....

 

[Guest]

bummer. Thanks!

You can't create two layers of tabs....