I do not have experience with macros. I copied and tweaked code to produce a consolidated/appended "Summary" sheet from 12 worksheets and it pastes in a header (2 rows worth) and formatting at the end. As far as I can tell, the "Summary" sheet is producing & updating what I want correctly every time I run the macro.

I created a pivot table on a separate sheet, same workbook. The Data Source for my pivot table is tied to "Summary" cells A2:J5000.

When I rerun the macro to update my "Summary" sheet, then hit "Refresh" on my pivot table, I receive an error about my name field not being valid and needing labeled columns.

I go to edit the pivot Data Source directly and it shows it as A3:J5001 instead of A2:J5000.

Each time I run the macro, the data source for the pivot table goes down one more row unless I manually reset it to what I want.

I do not know what to do to fix it. I just want to be able to refresh my pivot table with a single click without needing to fix the Data Source each time.

Thanks in advance for your help and patience.

Please Login or Register  to view this content.