Refreshes the pivot tables. One of them breaks — the pivot table source range needs to be extended to include the new rows. Updates the range.