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

Your help is certainly appreciated...!
However, Is it possible to get this done in MS Excel as I can understand the Excel comparatively better than VBA...

This problem is a combinaation of Multiple Lookup and Dynamic Drop-down...

I am able to get all the Tasks assigned to one person by using the logic for Multipe lokkup, but I dont know how to get the same in a Drop-down..

I can get the Tasks assigned as follows:
Sarah Activity 1A
Activity 11A
Actvity 111B
Activity 2B

But all the four Rows are relating to one person..Sarah..

However in a Drop-down, the List would be for a single Row.

So how do I solve this crux?