Since there was some code provided in another thread just recently which locked all columns other than that with a current date header, is it possible to make a sheet active based on a date?

Since today if Friday (here in Australia) then only the Friday sheet would be active and you could past to the active sheet.

Its just an idea, but if you want to roll round of the floor laughing your proverbial off then feel free.....