Macro to make new sheet when clicked once and next time it should go to the newly created

Hi Guyz,

I am a newbie to VBA coding. Therefore I am not sure if this is possible or not.

Basically I want to make a button which when clicked once will go make a copy of a sheet named "template", but when it copies it will tell the user to enter the name of sheet. And once the user makes that new sheet and fills in the fields in the new sheet, the next time he clicks the same button it will take him to the page he has created before when he clicked the button the first time. Hope this makes sense

For example , User clicks the button "noob", excel makes a copy of a sheet named template in the workbook and asks the user to enter the name of the sheet, the user enters the name of the sheet as template 22 and fills in this sheet. Next time the user clicks the button "noob" it will take him to the sheet template22.

I am using this code to make new sheet as of now

Plzzzzzz help!

Yes..basically he'll click it, create and name the sheet and then the next time he clicks the same button it will take him to the sheet he just created . Hope its clear. And thanks a lot for your quick reply.

Sorry just thought of one more thing, he clicks the button and makes the sheet, but he deletes it and then he clicks the button again which allows him to make another sheet....is it possible to code it this way......Basically its like an if statement , if (the sheet is there) then (go to the sheet) else (make new sheet)....Sorry for the trouble chief.

This below code I use can be used to make new sheets, but it wont let me go to the sheet once it is created and I am not sure how to code that.

Sub MakeNewHeirarchy()

Dim ShtName$

Sheets("Heirarchy").Copy After:=Sheets(Sheets.Count)

ShtName = InputBox("Enter Tool Serial No.")

Sheets(Sheets.Count).Name = ShtName

Sheets(ShtName).Visible = True

End Sub