Macros to COPY pivot table selection in another pivot table

Hello

I have 3 pivot tables on one spreadsheet, when i choose an option in the first pivot table, i want all the other 2 pivot tables to automatically copy what i chose in the first pivot table.

see screenshot where first pivot table starts at row 303, i select email, my next pivot table which would be in row 403 should have the same option selected (email) and so on


can a macros do this? the rows the pivot tables in are always static and list of choices are also static

logic: if pivot table in row 303 = some option, then pivot table in rows 403 and 503 = this option in 303sample.png

thanks for the link! i see it only allows me to connect 2 tables, i actually have a 3rd table on my sheet, any way i can link all 3 tables together so that whatever i change in the first pivot table, the other 2 follow?

do you have an example of this? i tried multiple slicers but each slicer only pertains up to 2 pivot tables, if i want 4 pivot tables for example to follow what i select in the first pivot table will that be possible?