Vlookup values with Multiple entries

Greetings Guys,

Please i need someone to help me. I am not a PRO of Excel, but i know how to move around it abit. I just got this new job and one of my tasks is to compile an attendance sheet using data supplied to me. The way this data entry is being done is manual, and i spend lots of time going from name to name picking out what i need. Click here for the sample workbook, What i need to be done is this;

The file attached is an excel workbook with two worksheets; "Summary" and "April 03". What i want to do is automatically collect data from the "April 03" worksheet and summarize it in the "Summary" Worksheet. How?

1. I want to lookup an employee name, then

2. if the column of "Entrance/Exit" (D) = "Entrance Staff In" then the minimum time value entry corresponding to that column D, should be entered in Summary sheet\Column B\Entrance. OR

3. If the column of "Entrance/Exit" (D) = "Entrance Staff Out", then the maximum time value entry corresponding to that column D, should be entered in "Summary sheet\Column C\Departure".

Since the raw data has multiple entries in the name column, i become confused. I don't know how to combine IF() and VLOOKUP() functions to achieve this. Please, help.

Attendance Sheet.xlsx