updating a pivot table with current year's data

Roger,

Thank you very much for taking time to help. I stumbled onto the
OFFSET function and man, that is the answer! Once again, thanks for
the help!

Mike