You can create a pivot table from data on different worksheets, using
Multiple Consolidation Ranges, but the results might not be acceptable
to you.
There's information here, and suggested workaround to the limitations:
http://www.contextures.com/xlPivot08.html
Amanda W. wrote:
How do I combine 2 worksheets in the same workbook, so that I can create a
pivot chart? The only problem I have is that if I try to manually combine
the two worksheets, I don't have enough rows.
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com