Sorting on Multiple Sheets with Same Macro

I'm having trouble with getting a macro to change when I copy a sheet and rename it. I've put a macro button on each sheet and when I copy the sheet out and rename I still want the macro to work for the new sheet name. Currently when I hit the sort funchtion it refers back to the original sheet and sorts it.

Thanks

Here is the current code. The sheet name is "Delray-D". I want to be able to copy the sheet and rename to "Bob". I want the macro to sort rows 7-300 on the "Bob" sheet the same way it did in "Delray-D" sheet.
Thanks

Please Login or Register  to view this content.

Worked like a charm. Thank you!