Pivot Tables using multiple worksheets

[AlanMB]

Hi,
I have a workbook with 12 worksheets (one for each month) with around 40,000
records in each. Is it possible to create a Pivot Table to enable me to
analyse the whole year?

Any help will be greatly appreciated. Thanks Alan

 

[Debra Dalgleish]

You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

http://www.contextures.com/xlPivot08.html

Perhaps you could store all your data on one sheet, or in a database,
and create the pivot table from that.