How to Create Summary Workbooks in Excel 2003

1. Launch Excel, and open all of the workbooks you want to summarize.
2. Click the 'New' icon to start your summary workbook. Format the cells as you would like them to appear before importing your data.
3. Go to the first workbook you want to include in the summary, and click the cells you want. Click 'Ctrl C' to copy them.
4. Return to your summary workbook, and click the empty cell where you want to include the data. Click the 'Home' button and select 'Paste' and then 'Paste Link.' Repeat Steps 3 and 4 with the data in all of your workbooks until your summary is complete.