I have several sheets with a pivot table in each sheet.
Each pivot table has the same structure of data, with 2 columns and 5 rows:
5 labels with a numeric value and the percentage of the total associated.
I want on my "main" sheet, to summarize on 5 cells, the 5 values for each table.
For now, I just add each value by referencing cells, but if I expand or hide one or more rows, cells which I try to reference disappear or change position.
Is it possible to get a specific value from a pivot table, no matter if I collapse or hide part of the table?