Hi All,

Here is what I am trying to do.

I have 3 sheets (A, B and C) for 3 different processes to track the overtime
of the employees.
I have a summary sheet on which I have a dropdown that lists all 3
processes. Now I want the employees' names to be returned when I select the
process name. For example, I select A in the dropdown, below that I want all
the names that are there in Sheet A. Rest of the information can be pulled
by vlookup once I have the key info.

Another thing. Once the formula returns the names, I would also want (in a
different column) the total OT hours of that particular employee. The name
can appear in all the 3 sheets. I hope it makes sense.

Thanks
Gaurav