Sickness Analysis

Hi,

Project:
I have been referred to the guru's of this site following good reviews so hope you can help.
I have a project for the workplace regarding sickness levels, basically what i need is a spreadsheet to highlight sickness through a yearly calender display.

Help Needed
I am using a list box (form control) to display the names of the staff. Next to the source data of names which this list feeds from is sickness days that staff have taken off. I need somehow to display each day sick in red on the calender by the member of staff which was selected on the list box so when you select the next advisor from the list their sick days appear only.

I have attached the file to make more sense of the above, i am not very good with VB either. Any help much appreciated.

Many Thanks,