I'm assuming you have some embedded button on your worksheet. These buttons are similar to vba modules in the sense that they can house code separate from the vba editor and can que up based on a wide variety of triggering events.
Based on what I see, the code looks more than capable to run on varying sheets (assuming the sheets contain similarly formatted data) as any cells not pertaining to the dummy worksheet do not reference a specific worksheet and therefore would default to the activeworksheet - i.e. Cells(1, 2).Value is the same as saying ActiveSheet.Cells(1, 2).Value.
So your solutions to use it on multiple sheets are to either copy/paste this button with the referenced macro to the sheets you want to use it on or create a prompt that allows you to input what sheet you'd like to use it with. The code would look something along the lines of;
Let me know if you have any other questions.
**edit - seems like you figured out what I just explained - Although, as noted above, you do not have to add "activesheet" as long as you are simply executing this code from the workbook.
Bookmarks