I have created a pivot table that pulls info from a large table. Each month before I update the pivot table I have a macro that copies the pivot table data and pastes it in a new worksheet. This is to create a "history" table to track progress over project duration. After doing this, is there any way to append the "history" table to the existing pivot table? That way I could have multiple months of reporting in one pivot table.