1. In Excel 2007, click on the 'Data' tab and choose 'Consolidate' from the Data Tools group. For earlier versions of Excel (97-2003), click on 'Data->Consolidate.'
2. Define the reference ranges using the Reference box. Specify the first range you want to consolidate.
3. Click 'Add.' The reference you defined in Step 2 will appear in All References.
4. Repeat Steps 2 and 3 until you have defined everything you want to consolidate. Then click 'OK.'