Hi Stephanie

You will find instructions here.
http://www.contextures.com/xlPivot08.html

But be aware, that you may not see the result as you expect.
It would be better, if you could first combine all of your data to a
single sheet (assuming your version of Excel can accommodate theta
number of rows).
For consolidating data from multiple sheets, take a look at
http://www.rondebruin.nl/copy2.htm

--
Regards
Roger Govier

Stephanie wrote:
how do I do a pivot table with data that is on multiple worksheets?