VBA "update" pivot table fields

[ncheever]

Hi,

I have a pivot table that I need to update quarterly. The values are "Sum of 20134 DEC", "Sum of 20134 WAGES", and "Sum of 20134 EST". When I receive the new quarter's data, I don't want to create a new pivot table, but just refresh/ update the fields mentioned above.

I have set the values below as references for my vba code that update automatically in the spreadsheet.

E1 = Sheets("PT").Cells(1, 13).Value <---this equals "Sum of 20134 DEC"
E2 = Sheets("PT").Cells(2, 13).Value <---this equals "Sum of 20134 WAGES"
E3 = Sheets("PT").Cells(3, 13).Value <---this equals "Sum of 20134 EST"
F1 = Sheets("PT").Cells(4, 13).Value <--this is programmed to be the next quarter "Sum of 20141 MAR"
F2 = Sheets("PT").Cells(5, 13).Value <--this is programmed to be the next quarter "Sum of 20141 WAGES"
F3 = Sheets("PT").Cells(6, 13).Value <--this is programmed to be the next quarter "Sum of 20141 EST"

All I need to do now is select the pivot table(PivotTable5), select the older data field (i.e. "Sum of " & E1) and replace the caption and the datafield with "Sum of " & F1. I hope this makes sense.
Any help would be most ...helpful