Well, I know you can use the "multiple consolidation ranges" option in the
pivot table dialog box to consolidate multiple data tables spread across
worksheets. But it sounds like you want to bypass the underlying data for
each pivot table, and consolidate multiple pivot tables, instead?

Is there a reason you don't want to use the pivot tables' underlying data
tables as your data source?

Dave
--
Brevity is the soul of wit.


"Gordo" wrote:

Hi there,

I am trying to build a pivot table to combine the data from 10 other
pivot tables, each in a different workbook. Anyone know if this
possible, and if so, how to do it?

Thanks,

Gordo