Code won't work when sheetname is changed

Originally Posted by JBeaucaire

In the code above I see many references to Sheets("SF 1").... is that the name of the sheet module that this macro is installed into? If so, you can replace all the references with the word Me. and it will work generically.

How does that work sir? What if I would make a copy of the worksheet, would the codes still work?