Enabling current macro to work on current sheet it resides

Hi Everyone,

Right now I have a mass print macro set up with VBA. I currently have it set to print the "Template" sheet when I press the OK command button. I want to copy my template tab (like I did for Preseason Tab) and be able to utilize the same macro on whatever the new sheet is. I think its just a small Active Sheet switch, but I am a little lost. I put my excel sheet as an attachment. Thanks.

Kaper,

The changes work just fine. I appreciate your help.