sed wrote:
I have several workbooks and within these workbooks I have pivot tables. How
can I get all the pivot tables into one big "Pivot table"? I need all of the
data of the different pivot tables into 1 master pivot table...
Thanks!

I think you need to start by having all your data in one place. Is that
feasible for you?