Changing the Pivot Table Source with the Dropdown List

Excel file teaching how to perform Changing the Pivot Table Source with the Dropdown List operation.

Excel Template for Changing the Pivot Table Source with the Dropdown List

Data ranges are defined in the drop-down list. The selected range is assigned to the pivot source. The summary table is refreshed after the update. The solution makes multi-page reports easy.

Hope it is useful.