How to Merge Multiple Workbooks in Excel 2003

1. Open Excel on your computer. Make sure that each workbook to be merged has a unique name and is located in the same folder on your hard drive.
2. Open the workbook that you want to merge all changes into.
3. Go to the 'Tools' menu and select 'Compare and Merge Workbooks.'
4. Save the workbook, if prompted by Excel to do so.
5. Select the workbooks to be merged into the currently open workbook, by clicking on the name(s) in the 'Select Files to Merge into Current Workbook' dialog box. To select more than one file name, hold down the 'Control' key while clicking on multiple file names. Click 'OK.'