Macro to create pivot table

Hi all,

Im hoping you can help me. I'm trying to build a macro for a pivot table. I have ran into an issue which I couldnt find a way of resolving. It relates to the sheet name, when I click on create pivot table, a new sheet is inserted but never the same sheet name i.e. I get sheet 2, then sheet 3, then sheet 4.... (during testing)

Im trying to make the sheet name that is inserted constant so that the command works smoothly.

Any ideas would be much appreciated.

This is where the issue lies:

Please Login or Register  to view this content.

This is what I do to resolve this issue (I rename the tab I add):
**************************************

Please Login or Register  to view this content.

**************This Renames the Tab***********************