How to consolidate multiple Pivot tables?

Hello,

I would like to know if there is a way to consolidate multiple pivot tables and get the results in the same format?

eg:
Sheet there are 10 sheets with the same data as below:

I need to consolidate all the 10 sheets so that the result also comes in the same format. When i consolidate i am getting the result in this format:


The alphabet under Area is totally missing and it is replaced by numbers. I want that corresponding Alphabet also.

Any way this can be done?

Thanks,

try see instructions here or here

Use Power Pivot and Power Query