How do I set up a pivot table across multiple pages of
data? My lines of data total over 70000 and therefore are
contained on multiple worksheets. I was able to get the
pivot table set up to pull in both worksheets but wasn't
able to change the columns or veiw the detail.

Thanks.