Consolidation of Multiple worksheets

[hedgie]

I have a very data intensive workbook. There are data sheets for each of the months of the year. Each sheet has 19 columns of data with 10,000 to 12,000 rows. THe columns are identical across each sheet. I want to consolidate the data into a pivot table that would sum the entire years worth of data. I have already successfully created a pivot table on a single month which accurately sums that months worth of data. The problem is the quantity of the data. Anyone have a suggestion on how to best handle this? Using the multiple worksheet option to consolidate in a pivot table has the computer hanging even if I only try January and February together. I am certain the entire year is out of the question by that methodology. (For the record I have named each months data range to include the columns ($A..$S) - so blank rows are included.)

Any thoughts?

 

[KenoshaCanuck]

Have you thought of importing your Excel worksheets into Access, and combining them via a query/join. You can then export your newly created query file into an Excel pivot table for manipulation as needed. Just a thought, though I'm sure there are other ways to accomplish your task.