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

--
Regards
Roger Govier



"ckane" wrote in message
...
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?