Pivot Table Name Changed Every time when Macro Runs

[sg2209]

Hi Friends,

I am new to VBA, learning by watching videos, reading forums, googled and taking help from Excel Forums.
i am facing an issue with the below code where from Sheet 1 data copied to sheet 2 and then it insert a new sheet and Pivot Table gets Created , there is another sheet with source data named Deepsee an another Pivots Created in another sheet 2 however every time Pivots name gets changed and macro for Pivot Table 2 does not work exactly as per requirements, Shall anyone please help me , below is the code :-