Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

Dear all

I have two tabs with 2 pivot tables (1= Customer Analysis, 2= Product Analysis). In pivot 1, I want to choose the customer name in a filter; this customer name should automatically be pulled by pivot table 2 as well. How to do it? Please see attached "Tool" for my data.

Moreover: what is the macro that automatically calculates all formulas fresh once I have filtered?

Thanks and many kind regards