Hello everyone! I have a question and I don't know if there is an answer for this.

I have a series of pivot tables that generate reports based on a series of filters. One of them is territory.

These reports are linked to a scorecard that shows metrics per region. This scorecard has a cell in which the person can choose the region.

I would like to know if there is any way for these pivot tables to be linked to this cekll, so that they refresh showing the corresponding metrics (not having to go pivot table by pivot table changing the region).

Can this be done?

Thanks!!!