Creating a Non-contiguous list in a drop-dowm dynamically.!

[all4excel]

Creating a Non-contiguous list in a drop-dowm dynamically.!

I want a Dropdown which only selects all the Activities pertaining to whatever mentioned in the Column E.
For ex- I want all the Tasks assigned to Sarah , so I would be getting a choice amongst all the Tasks colored in Blue in a Dropdown, so If I were Sarah, then I would choose any Activity out of the 4 mentioned.
This dropdown would be based on the selected in the cells E2..