Keep Macros Executing on Copied Worksheets and not on the Original Worksheet

[Snake Eyes]

I have a worksheet with macros created and running when their assigned button is clicked.
When I make a copy of the sheet, the macros still run but against the worksheet in which they were created and not on the copied worksheet.

How to I get the macros on the copied worksheets to run against those worksheets regardless of their name?

 

[Legacy 143009]

I think you might be able to use Me namespace to refer the worksheet containing the code. I usually use for form objects. I reckon you should be able to use it also for worksheets since a worksheet is an object, too. For ex:

Me.Range("A:A")

In the given example, the range should always inherit the worksheet that it is running in. At least in theory. I have no chance to test it now unfortunately.