Formula required for list creation within worksheet

I think the following is what you want.

First I played with your data: I "normalized" it by repeating the Selections on each row in column A. Then I converted it into an Excel Table. Select any single cell in the data range, then select Home > Format as Table and follow the prompts.

Then I created a couple of pivot tables as shown on the pivot table sheet. I added a slicer. Select any cell in the pivot table and then select Insert > Slicer and follow the prompts again.

The next step is to hook up the slicer so it controls both pivot tables. Select the slicer. Click on the Slicer ribbon. Select Report Connections - this will give you a list of all pivot tables that are built from the same data source. Check the boxes for the pivot tables that you want to associate with this slicer. So make sure both boxes are checked. Now when you select an item or items in the slicer, it will update both pivot tables.