How to Use Multiple Consolidation Ranges in Excel 2007

1. Launch Microsoft Excel from the 'Programs' or 'All Programs' menu. Click the 'Office Button' in the upper left corner of the program window and select 'Open.' Navigate to the file you wish to consolidate the ranges of, and select it. Click 'Open.'
2. Click the first worksheet of the range that will be consolidated to select it. Click the 'Home' tab. Select 'Insert' and then 'Insert Sheet' to insert a new sheet for your consolidated range. Double click the sheet name tab at the bottom of the program window to select it. Type a name of your choice. Press the 'Enter' key on the keyboard.
3. Click in the upper left cell of the area where you want the consolidated data to appear. Click the 'Data' tab in the 'Data Tools' group. Click 'Consolidate.' Click the downward pointing arrow to the right of the 'Function' drop-down box, and select the function you want to use to consolidate your data.
4. Click the select range button under the 'Reference' heading. Click the tab on the bottom of the worksheet with the first range to be consolidated. Select the range of cells to be consolidated. Notice that the range appears in the 'Consolidate -- Reference' box. Click the select range button to collapse it. Click 'Add' to add the range in the 'All references' list box. Repeat this step from the beginning for all worksheets.
5. Select 'Top row' under the 'Use labels in' heading, to have the column headings appear. Click 'Create links to source data' to have the data on the consolidated worksheet automatically update when the data on the other worksheets changes. Click 'Ok' to display the consolidated range.
6. Click the 'Office Button' in the upper left corner of the program window, and select 'Save' to save the file.