If you can get your Diff values into the WrkingSheet as I have done, then the pivot table only needs to be refreshed.
You may be able to get a formula to fetch the Diff values from the other books, or a macro or a Power Query query, it all depends on where you're getting the data from.
Note that I've changed the data on the WrkingSheet to a proper Excel table (called Table1) which means that you won't have to change the pivot table's source data reference at all when updating, you just have to make sure the extent of the table covers the data you want to pivot (see the grab handle at bottom right of cell F14).
|