Consolidating several worksheets into one pivot table

[Lilia]

Hello,
I have 12 worksheets with the same data separated by months (each worksheet corresponds to a different month). This data changes every month.
Is there an easier way, other than creating a summary sheet to combine them all in one pivot table? And whenever I update one of the sheets all I have to do is refresh the pivot table?
Thanks,
Lilia

 

[Villalobos]

Is this help for you?
https://support.office.com/en-us/ar...e-report-3AE257D2-CA94-49FF-A481-E9FC8ADEEEB5

 

[Lilia]

I tried it but the files are so large that the computer freezes before the tables are created.

 

[Villalobos]

And what about the Data Model technique?

If the data on sheet Oct16, Nov16, Dec16 are in Tables then you can integrate these tables into 1 pivot table.

Or VBA.