Pivot Table

[Guest]

I have created a pivot table based on one worksheet. I have about 25 other
worksheets with the same headings but different info. How do I combine data
from sheets 1 - 25 into the one pivot table which is on sheet 26?

 

[Roger Govier]

Hi

Creating Pivot Tables from Multiple Consolidation ranges gives results which
might differ from what you expect.
Take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot08.html