Here are my sheet 1 column headings:
Client #, Client Name, Location, Employee, Date

On Sheet 2, I want to show every instance where an employee did billable
work on a certain date, and show which client they were working on.

Ex: If Kevin (column d) did billable work on date x (column e), who was it
for (column b)?

Sheet 1 is constantly updated and I want sheet 2 to reflect all changes.

Thanks in advance to anyone who can assist with this issue.