Sheet and pivot table update

Perhaps this will help with updating a sheet in the same workbook (modeled on the New Format sheet).
1. Convert the Raw Data into an Excel table
2. From the data tab select "From table/range" to put the table into Get and Transform (aka Power Query) and apply the following code:

Please Login or Register  to view this content.

3. Load the table that is produced to a sheet.
4. When a new row (or rows) is added to the raw data table then from the pivot table analyze tab select the refresh drop down arrow and then refresh all
Let us know if you have any questions.

From the data tab select "From table/range" and look for Advanced Editor in the right end of the ribbon on the Power Query Editor window.
Select Advanced Editor and paste the code from post #2 into the Advanced Editor window.
Let us know if you have any questions.