Get data in one sheet

[anto1510]

Hi All,
I have attached a sample work sheet.In the sheet Leave tracker i update employees leave or off request.
in the sheet Agent wise Leave or Off Tracker i want to get the values agent wise.
Once the auditor enter the agent id he should know the type of request employee maid for the mentioned periods and all the dates of leaves or offs.
the one highlighted in yellow is the field the auditor need to enter and the cells highlighted in green should be the output.
showed sample output.
Thanks in advance