Combine Workbooks

[gsxith3]

I have six workbooks, each containing around 60 pages. I want to combine them in to one workbook- keeping hyperlinks and formatting. What is the easiest way to accomplish this? Thanks for any suggestions.

[Paul]

Hi Gsxith3,

You should be able to copy the worksheets to the one master workbook. For example:

1. Open workbook1 and the master workbook.
2. Select all of the sheets in workbook1 (click on the first sheet tab, hold SHIFT, click on last sheet tab)
3. Right-click on one of the sheet tabs (they should all be white now) and select 'Move or Copy...'
4. Change the 'To Book' drop-down to the master workbook.
5. Select 'Move to End'
6. Check the box for 'Create a copy', then click OK.
7. Close workbook1, open workbook2 and repeat.