Hi Excel veterans, I seek your help!

To greatly increase my own efficiency, I seek an Excel 2003 compatible events calendar which can take data from one worksheet (tabular format) and have a calendar format generated on the next worksheet with the dates and info corresponding to the original worksheet.
General rules I can think of..

1) 2nd worksheet must be in calendar format, monday tuesday wednesday etc.
2) 1st worksheet is purely data entry, where event name will appear in calendar on the corresponding day
3) multiple events can take place in one day, ideally around 5 or so..
4) Must be fully compatible (or at least workable) in Excel 2003
IF POSSIBLE:
5) Calendar is able to capture no. of days of that event
6) Color coding for that line item in the calendar, say 5 colors for 5 conditions

Are there any templates out there which can fulfill at least the first 4 request? if so please do link =) I have looked at so many calendar templates and I only see one that fits the bill but that is not fully compatible with Excel 2003 =(

Thanks for the help in advance guys, you guys rock!