How to Consolidate Worksheets in Excel

1. Turn on your computer and open the Excel spreadsheets that need to be consolidated.
2. Consolidate spreadsheets by position, category, formula or by using a PivotTable. For this how-to we are going to be consolidating by category. Begin by making sure the format is identical in each worksheet. For example, 'Annual Avg.' and 'Annual Average' are seen as different and won't consolidate together.
3. Next go to the worksheet that you want to consolidate and click 'Data,' then choose 'Consolidate.' This will open the Consolidate box.
4. Specify the range by using the Reference box in the window. Click 'Add' to move the range to the 'All References' box. Continue adding ranges until all are defined.
5. Check the 'Create links to source data' box to add links back to the original data. Then click 'Ok' to save and perform the consolidation.