I have 9 coleagues who insert their holiday dates onto separate sheets in an
Excel workbook.(The sheets automatically update - days taken, days left etc.)

I want to access these dates and display them all as coloured bars on a
single summary sheet. over a given year. ( Months on top, Names on Left, and
bars indicating holiday dates in the correct order.)

I have tried MATCH and conditional formatting to some degree but I can't
seem to set range of dates.

Any ideas please

Regrds
Lofty