Combining Single-Select Filters on Multiple Worksheets into a Multi-Select Summary on one Worksheet

[Anonymous]

Hello,

I have created a tool that where you utilize 10 different worksheets to filter on a home's plan design, then it does some statistical magic to determine if the plan design passes a basic test. Currently this has to be represented on 10 different worksheets, but I would like to have a summary worksheet that contains each filtered plan from each worksheet.

Right now, I cannot figure out how to do that of course. Which is why I am here.

Here is an example of a worksheet with a single-select filter. So, imagine 10 of these where the division stays the same, but the plan name differs.

Then, here is the summary table where I cannot figure out how to filter Plan-Names into the 10 Plan Names that are selected on my 10 worksheets single select filters.

Any help would be greatly appreciated.

[parry2k]

@Anonymous even though you have 10 pages, is data coming from single table? And all these slicers are from that table? How does your raw data table looks like? Share some data sample?