Pivot table from diferent worksheets

[Daniel]

How can I create a pivot table from data of 3 diferent worksheets ?
Thanks
Daniel

 

[Debra Dalgleish]

You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

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

 

[Ian]

Daniel,

You can use a ODBC UNION query with three parts to point to each of
the three different worksheets (I assume they've got the same
format). This makes the data appear as if it is coming from a single
source so far as the pivot table is concerned. It's a wee bit messy
to do but could probably be automated relatively easily with VBA.

Ian