How to change macro to specific worksheet

Hello, I am currently writing a program to create a rota at my office. The rota is created on a master page and using a macro is transferred to a new worksheet, named after the rota date, containing 4 different templates, one for each floor. I also need to print out a daily register by going into these saved sheets and printing out a specific day onto another worksheet. My problem is that although the macros for each day are copied when i create a new rota, they take their references from the original sheet each time instead of the current one. Is there anyway to change the macro to use the current rota date when copying info over instead of the original. The original worksheet is called rota, but the new one is called 22 MAY, however the macro always say Sheet("ROTA").Select, instead of ("22 MAY") if you know what i mean. Hope someone can help me
Thanks.

Thanks will have a look.