I have a worksheet that has multiple pivot tables all coming from the same source. However I would like to be able to have the ability to see one or all pivot tables on the worksheet. I tried using the Page Area to do this but I lose the ability to see the data elements in the Page Area (i.e. - Country in the Page Area but can't see individual countries as part of the pivot table itself like Argentina, Canada, USA and etc.).

Does anyone have an idea?