Creating A Staff Holiday Spreadsheet

Hello,

Currently I'm working on functionality in my staff holiday spreadsheet and I've come up with this amazing idea for a calendar overview for month by month.
Now the sheets I currently have is summary and jan to dec.

I plan on adding the sheets Jan (Cal) to Dec (Cal) now this is when my idea gets nifty - The calendar view will import the information from the month table and will show it on the calendar.

For example X has 1 holiday in July for the 20th - this will show up on the calendar as "x on holiday", I'm still working with spreadsheets so I'm not sure if excel is powerful enough to do this - but is this actually possible?

Originally Posted by AndyLitch

Oh yes LOL..........

Simple yes/no answer would be nice.
Preferably yes with some sort of idea on how to do it.

Not sarcasm.