Linked workbooks are a database in disguise, so it's time to treat them like one.
One selector can replace a stack of nearly identical Excel reports, while FILTER handles the changing results.
Microsoft is rolling out Excel Canvas, a Copilot feature that turns workbook data into a report with visualizations, metrics, ...