Synch Slicers with Different Data Sources

[hovictor]

Hello,

I am trying to figure out a way to synch multiple slicers that are connected to different PivotTables on different worksheets. The relationship is a bit complicated so I'll try to illustrate below:
_______________________

Slicers:

1. Slicer_Province
2. Slicer_Site
3. Slicer_Province1
4. Slicer_Site1

PivotTables (each is in separate worksheet):

1. Rent1
2. Rent2
3. Expiry
4. Renovation1
5. Renovation2

Connections:

Slicer_Province & Slicer_Site

• Rent1
• Rent2
• Expiry

Slicer_Province1 & Slicer_Site1

• Renovation1
• Renovation2

All slicers are on a 6th worksheet, my main dashboard worksheet.
_______________________

How can I make it so that when I filter using Slicer_Province, it also filters Renovation1 and Renovation2 (thus updating my entire dashboard), and the same for Slicer_Site, as opposed to having to operate Slicer_Province1 and Slicer_Site1.

Thank you!