Transferring Data From One Worksheet To Another If A Condition Is Met

[bunni1031]

I have a 2 worksheet excel workbook. The first page is an employee scheduler. Column 1 is the employee's name, column 2 is the client's name, column 3 is the service completed, column 4 is the appointment start time, column 5 is the appointment end time. The second worksheet is very similar, but column 1 is the client's name, column 2 is the employee's name, column 3 is the service, column 4 is the start time, column 5 is the end time. I am entering all of the schedule info into the 1st worksheet. What I need to figure out is how to get the second sheet to automatically search for each instance of a client's name for that day and fill in the employee that provided the service, the service, and the start and end times. How can I accomplish this?

A short example is attached. In the full workbook, I have about 40 employees and over 60 clients.
Example2.xlsx

[Excel Fox]

What if a client is serviced by more than 3 providers? Will the number of rows not increase? How can you assume that one client cannot be serviced by more than 3 providers?

[bunni1031]

I am increasing the number of rows to 6. There will never be an instance when more than 6 are needed.