Copy worksheet and pivot table
 

Hello,

I created a Pivot Table. I wrote a macro to copy the worksheet. The problem
is that the Pivot Table continues to reference the original sheet. How do I
make the reference stay with the new sheet? I have another macro that
refreshes the Pivot Table and it's creating an error because two Pivot Tables
are referencing the same data.

Is there a way around this?

Thanks