I need to create a workbook for each month of the year. Each workbook needs
to have a worksheet for each day of the month.

I want to be able to create the worksheet for the 1st of the month and be
able to copy it out 30 times, once for each day. The header of the worksheet
has a date field. I don't want to manually have to update each day of the
month, so how can I copy the sheet for day 1 so that the date chages to the
2nd, 3rd, 4th..... 31th as I copy it.

I hope the question makes sense... any suggestions are appreciated.