Pivot tables

on your keyboard select Alt D, then P. This will bring up a pivot table wizard. Select the "multiple consolication ranges" option, go next, and next again, select the range and make sure you click on add. then your done.

The pivot table from multiple sheets isn't as flexible as a regular pivot table -- all the data fields use the same summary function, and there's only one row field. However, while you're setting up the pivot table you can create one or more page fields, and create labels for the data ranges.