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?