Pivot Table to reference multiple sheets

[massa]

I need to create a pivot table that references the data from 2 worksheets.
I have tried the consolidation method but am confused when the field list
does not carry over my column names.
Can someone please advise?
Thanks.

 

[Debra Dalgleish]

Using multiple consolidation ranges creates a pivot table with several
limitations, as described here:

http://www.contextures.com/xlPivot08.html

Perhaps you can move all the data to one sheet, or a database, as
suggested in the article.