Set Cell to Copy hidden Worksheet to End & Rename with input box

Good day,
I'm seeking assistance as I have most of the VBA code written out properly, however when creating a copy of a hidden worksheet the input box is not associating to the new worksheet and continues to want to rename the first copy worksheet. Please see the code below. Any assistance would be amazing!

Please Login or Register  to view this content.

Try adding this line...

Please Login or Register  to view this content.

Hello. Another way:

Please Login or Register  to view this content.

This worked well! Thank you

However i decided to utilize this as it helps me learn a bit more about VBA. Thank you very much!!