Problem updating source for pivot table

I have a pivot table that uses data from a different sheet.
The number of rows and columns changes from run to run.
I want to update the source the pivot table uses.
Here is the code I am trying to use below. I get the run time error 1004 on the highlighted line.
Suggestions?

Thanks.

Please Login or Register  to view this content.

Using this for the highlighted line resolved the problem:

Please Login or Register  to view this content.