Here is where Excel pivot tables step in to extract data ... select PivotChart Analyze at the top, and select Refresh to update the data. You can also expand Change Data Source, pick a different ...

You can filter connections, refresh pivot tables, change data sources, and connect multiple pivot tables from the top menu. It’s one of the effective ways to maximize productivity in Excel.