help with writing IF formula

Hi
I am having some trouble writing an IF statement. I think it may be more than an IF statement that is needed, but not sure what to do. I have attached an example of what I am trying to achieve. Sheet 1 is a rota, and H indicates holiday. On sheet 2, I want to see the actual booked holiday dates booked by each staff member. On sheet 1 of the attached example, I have made a rota, and on sheet 2, I have typed in the dates, as to how I need it to look.
Any help would be greatly appreciated.
many thanks