Dynamic Excel Calendar

[dolphin_m70]

hello
I have Excel 2002. I am trying to design a dynamic work calendar. I am not an expert in programming so need some help.
where i will input the

1. Start and end time for work (eg: 7:30- 12:30) with the total hours worked displayed in this eg its 5 hrs.
2. My Job no (eg. 550) and date.
3. Also there should be an option for Selecting a date as annual leave or rest day or none of both.
4. Once the above details are inputted, excel should output a dynamic calendar for every month.
5. Different days are color coded ( eg: white - normal day, blue- rest day,pink - annual leave, brown - rest day work)

The calendar should look like the one attached, when generated. Any help would be highly appreciated

thanks