https://spreadsheetsolver.com/posts/pivot-table-refresh-data/
Pivot Table Refresh Data