Code won't work when sheetname is changed

Originally Posted by Norie

Do you want code that will copy the 'SF1' sheet when a button is clicked on that sheet?

YES!!! PRECISELY!!!

Originally Posted by Norie

Do you want the button to be on the new sheet?

I want it on the original sheet which when that button is clicked and a new sheet is created, that very same button is also there on that new sheet, the same way the other buttons from the original sheet are all working perfectly.