When I create a pivot table for the first time, the cell references are fixed
in R1C1 format. I would like to have a macro that will enable me to create
the same pivot table, and at the same time, update those references to the
range of data that would have changed from time to time. Right now I'm stuck
when trying to change the source data code in the Visual Basic editor.

Currently using MS excel 2003.