Auto-populating Cells On Separate Sheets?

I have two spreadsheets, one is a Log Sheet for invoices that we have been printing out and filling in my hand throughout the day as our field technicians complete their work. The second spreadsheet has a sheet for each technician where we manually input the technician's invoice numbers and payroll for each job completed on that day.

What I'd like is a way to combine these spreadsheets so that instead of printing and filling in the first sheet by hand, I could input the invoice data and have it automatically populate the cells for the appropriate technician.

This is the running log we keep throughout the day:

2rp76ky.png

Then at the end of the day, we painstakingly transcribe the data for invoice number and payroll onto this sheet for each technician:

4vg6dk.png

What I want is for Excel to automatically fill in each technician's payroll log with invoice number and payroll time as we fill in the running log throughout the day, is this a doable thing?