You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example he

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

If possible, store your data in a database, or on one worksheet, and
you'll have more flexibility in creating the pivot table.


bvbvince wrote:
I've a pivottable which is based on many Exel-Sheets. Therefor I've set
the pivot with 4 individual sidefields, but it is not possible for me to
select the contents of these fields. Can somebody help me ??


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html