Multiple Pivots with Same Slicer - How can I link them all?

Hello,

I have been tasked with creating multiple documents in Excel that will eventually only report to the higher ups a 1 page dashboard. I have approximately 9-10 pivot tables that I need to link together in order to update the data from several different sources within the workbook.

When I add slicers to each pivot, I have been using the same field for each ("Name"). When I go to Report Connections to link all the tables, only a handful show up.

Can anyone please advise on where the other tables may be or how I can find them?

Thank you in advance!