template creator for sheets with dates

[Megatronixs]

Hi all,

I have added an excel sheet to make it easier to understand.
I have an excel sheet that I need to make as a template. the sheets 5 blocks that represent each a day of the week and the tab at the bottom of the sheet has the name as the first day till the fift day of the week. What I need is to create a macro that will produce for the whole year a template that I could use. So it will ask me to fill in a start date and then it will only create for the working days (not including the weekends) and mabye also exclude some days that are holidays (that could be taken from a sheet with the holidays written there).
It will need to create for each week a new sheet with the correct days acording to the sheet.

If some one could come up with an idea how to get this starting, would be great.

Thanks in advance.
megatronixs