Creating a dynamic Pivot Table
Creating a dynamic Pivot Table that refresh automatically begins with this kind of data:
Select the data range.
Click on Insert, and Table.
Click My Table has Headers.
Click on Insert tab, and choose Pivot Table.
Choose the fields on the right.
Click on any part of the Power Pivot, Analyze, and Options under Pivot Table Name.
Choose Data, and Check on Refresh Data When Opening the File.
The Pivot Table will now refresh automatically whenever you open the file.