Excel Wizzards please look in here please - basic pivot table help

[DoubleCheese]

I've got a workbook with 12 tabs/worksheets representing each month of the year. Each Worksheet has about 12 columns and upto 2000 rows of data. I can easily make a Pivot table of each individual worksheet, but I'd like one that encompases all the sheets. All the Columns are consistent across the worksheets.

I've tried to follow a few tutorials but can't get it to work. Using Office 2003 by the way. Any pointers?

 

[Participant]

Sorry, this doesn't answer your question - I've never figured out how to get one pivot table to look at multiple worksheets - but why can't you just have an extra column that says 'month', and have all the data on one sheet? Then you can easily filter by month both in the data and the pivot.