Thank for anyone help in advance. This problem is driving me crazy that I can not solve...

I have pivot chart that is filtering data by location. I need that the location filter to change when the cell in another tab in the wookbook is changed. The other tab is a report that the user can select from a list of locations.

So the user would select a location in A1 on Tab1 then on pivot table in Tab2 the filter would update with that selection. can someone please advise?

Thank you advance!