Pivot Table from Multiple Sheets

[rhmkrmi]

Hello there,

Can we create pivot table from multiple sheets?

I have 5 sheets in a workbook and their column orders are identical.
I need to create one pivot table using all 5 sheets as source data.

I can't combine the 5 sheets into 1 due to the volume of data.

Thank you!

 

[szita2000]

Hi rhmkrmi.

It is possible!

Press Alt, D, P key combination (one after each other.)
This will bring up the Pivot table and Chart wizard.

There, you need to select the multiple consolidation ranges option. Then follow the wizard and that should be it.