I have a table that keeps changing continuously with forecasts for each month. I have a report that has a pivot table in the summary worksheet whose source data is in a different worksheet. Every week, I update the source data table with the latest data and just refresh the pivot for the summary...