Consolidate Pivot Tables/Cache using Excel 2003

[Graeme]

Hi,

I have an Excel 2003 workbook with 20 worksheets. Each worksheet contains
one Pivot table.The Pivot tables all have a common structure and the same
number of fields. Is there a way to consolidate the individual Pivot tables
into one master Pivot table using VBA? Alternatively would it be possible to
use VBA to cycle through all the underlying Pivot Caches and copy all the
data to a new worksheet?

Any help/guidance appreciated.

 

[isabelle]

hi,

you could do a query on PivotTables sources