Copying sheets in a macro
 

is there a way to copy a sheet and add it to the workbook when the date
changes. say i have cell a2 as =today() and i want to make a copy of the
existing sheet when it changes (or tomorrow arrives). i would like to do
this for the entire month and then start over with a new workbook for the
next month.

i have found some code but cant get it to do what i want.