At the closing steps of a macro I'm writing I copy a sheet with a pivot table to the end of the workbook and rename it and the pivot table within it.
I want to change the data source to a new sheet, and when I recorded myself doing the action I have part of the code looking like the below...