Create a slicer linking 2 pivot tables from different worksheet

Liphor There were a couple of issues in your file:

1. The Append query contained two columns because you renamed the Catch column in one of its sources
2. The append query then needed a filter for unique values
3. The pivot tables need to be using the fields from the unpivoted table queries, not from the original tables
4. The Catch field for each pivot needs to be taken from the Appended Catch query, NOT from the table or the unpivoted table query
5. The slicer then needs to be on that Catch field and tied to both pivot tables.

See attached.