I have this report at the office that is used in Excel. Everything is done
manualy. The excel file has 4 main worksheet and one worksheet for every
single day of the month. It contains daily data in the individual day
worksheets (entered manualy) and the remaining worksheets contain totals from
those worksheet, grand totals and charts to display them.

The problem is that this is manualy changed each month to be specificly for
that month. Therefore, you have the month's name in there and the amount of
cells/worksheets depends on how many days there are in the current month.

I need to know how to create a macro (never done it in any Office products)
that will be manualy executed on the first day of the month to pick up the
date and then customize the whole Excel file (all the worksheets) to be for
that month alone.

I also want to add cell references in the main worksheets to automaticaly
pickup the daily values in the day worksheets (I can do that manual but it is
so long to do).

How can I do it ?
I want to know how, learn how to do such things so I can do other future
customizations on my own, and do it this week too.