Help with Data validation and list with formula

[compspider]

Hi guys,

Long time since I have posted anything.
I need your help, I am trying to make a simple planning sheet.

I have a workbook with 2 sheets.
1.sheet contains Columns : Day Date Time Class Teacher Covered
2. sheet contains the availability of teachers. so all columns start with a date and the rows contain the name.
A row therefore looks like this.

7/1
Harley

Lidia
Livia
Thais
Salete
Carla


My issue:
The 1.sheet has a column Teacher, now in this column I want to have a drop down list. (E2, E3, E4, E5 ... etc..)
This list is depended on the date which is in column B.

Essentially I want the list to look up date in its row go to the second sheet and give me all the possible names in it. That is all.
Is this possible ?


.. See my attachment.