I need to analyze about 60mb of data on different speadsheets in Excel. I am
attempting to build pivot tables to look at the data.

How do I build pivot tables from several different worksheets in a workbook?
All of the data is in columns with column headers but I can't seem to get it
to pivot correctly to give me the results I need.

Please help...