Convert inputted dates to visual calendar

Morning,

I have created a holiday calendar for my work but as I am new to VB I am really battling to automate converting the dates for each persons leave into a colour/highlight on the calendar sheets to highlight dates they are away.

I have attached the file, hols2.xls, so you can see my effort so far, and any input will be much appreciated.

A summary - 3 sheets:

Employee Data - All employee data (minimal for privacy), 10 seperate holiday request inputs (Also a conflict error message for employees carrying out similar roles)

Jan - Jun - This is where I want the holiday dates booked in "Employee Data" to be coloured.

Jul - Dec - This is where I want the holiday dates booked in "Employee Data" to be coloured.

I have created a calendar with a shortcut CTRL-Z, which i now realise is undo, just to warn you.

Thanks for the help.

Regards

Warren