I previously created a workbook in excell 2000 it had 16 pages of data. I
created a pivot tabel to gather all data in one report. It mostly had totals
for scores with multiple players at multiple locations with totals for each
player at various locations. Even I'm confused after that. Now I had to
reload windows because of a virus my kids got from downloading misic. I had
to recreate all the documents. I now have Office 2007 and can't figure out
how to get the data from more than one sheet. Please give me step by step
instructions on how to get data from 16 sheets into one pivot table all from
the same workbook.

Thanks TJ