Instead of importing into Excel, you should import or link into Access. Then
when creating your Pivot Table in Excel, link to your database.

This is much cleaner, than creating multiple worksheets.

"PT Cruiser" wrote:

I have data in a spreadsheet in excess of 65536 lines so I have the data on
more than one page in a workbook. How do I create a pivot table that will
use more than one page of data to create the pivot table? Is it possible?