Say I have 12 different workbooks (1 per month). In each is a pivot table based on about 16,000 rows of data.

The pivot table fields are the same in each workbook. Is there an easy way to combine/merge the data from all 12 workbooks so that the new pivot table will be based on all 12 months of data?

Thank you

j