I am trying to create a simple to maintain PTO register.
I have one sheet that will have the following:
Name
Date
Hours
Each line will represent an employee and the date in which they are taking as leave along with the number of hours taken
A second sheet will have the employees names along with their entitlement for the year (in hours)

I am trying to create a third sheet that will be a statement showing what their entitlement is, which days they have taken and what their remaining entitlement is.

Is there a formula that will "list" the line items from the first sheet? incorporating a vlookup as I want to be able to either type or select the employee from a drop down menu so that I can have one sheet for all.

Thanks in advance