Holiday calendar with shifts for staff

Hi, I want to make an excel holiday file which will be able to list all employees against a quick view calendar (150 of them) - I have this bit done - but be able to have a day view list of the people who are off and the hours they all work (to arrange agency cover for them).

So a standard format front page, but be able to click on the individual dates, get a list of the people who have been assigned holiday in the chart, and the hours they normally work (and other details). I can get the hours normally worked etc to feed in using a vlookup table I am sure, but am not sure about how to pull the front sheet to transfer the names to a list if they are on holiday that day.

Thanks

Hayley