I hope I can explain this properly

I have downloaded an excel multi-year calendar form the internet and I am in
the process of modifying for my work.

On a second worksheet I have boxes that require user input on various types
of annual leave. Using a CommandButton I would like to transfer that
inputted information and format the the calendar to incorporate this data by
colour coding cells.

Please help

Frances