Hi Browser,

This is a bit of a big ask. It would a whole book to tell you what you
need to do here and how to do it - in that vein I can recommend the
John Walkenbach, Power Programming in Excel books.

To start you off with the basics I'll give you a few pointers - this
is how I would approach it but there are many ways to skin a cat.

I would recommend you begin by creating an Excel Template (*.XLT) that
contains copies of the 4 main sheets you mention and a single day
sheet containing whatever formatting, headings, formulas etc. all your
day sheets normally contain.

Then in the ThisWorkbook module create a Workbook_Open procedure that
copies the day sheet as many times as necessary for the current month
and put the relevant date type info in the relevant places throughout
the workbook.

The idea being that the Template remains unchanged by the user. Each
month they launch the template once and it creates a separate workbook
to be used for that month.

Now I know that's not giving you a lot to go on but to be honest it
would be a lot quicker and easier to do the job for you than explain
exactly what you need to do. If you genuinely want to learn, get
yourself kitted up with a JW book and have a stab. When you get stuck
post back to a new topic with a question on the specific problem.

HTH - I don't mean to lecture ;)

Br, NickH