Matching dates and returning another column

Hi all

I have a summary sheet with a list of dates in column B, I want to check data sheet with dates in column C, when a date matches, return the data in column G. Should be simple.....but I cannot for the life of me get it.

To complicate matters a bit, the date cells are groups of nine rows.....merged, but the data needs to come from the individual rows....

I have attached a stylised sheet.....what I am aiming to achieve is, look at sheet one date, match the date on sheet 2 and return the instructor requirement by period for that date, and then same for sheet 3 etc etc.

I am sure it is a simple fix for the gurus out there!

JM