I am trying to create a workbook for my payroll accrual each month. I would like to use 3 worksheets.

Sheet1
I would like to use sheet1 as my "source document". I run a hours worked report (by employee and by department) from my operating system. If an employee/department did not work, they are not shown on the report. I can export this report in excel format. I'm thinking of using this - copy and paste it into sheet1. I would need to run the report each month, export it into excel and paste it onto sheet1 each month. If all works properly, sheet2 and sheet3 would then populate the necessary info that I need. Here is what the report from my operating system looks like:
HOURS PAY

Regular OT DT Total Regular OT DT Total
Department Worked: 01 - Law Office
Position Worked: 11 - Paralegal 10 5 2 17 1000 10 2 1012
Position Worked: 111 - Secretary 15 1 5 21 500 40 20 560

Sheet2
This is my input sheet. It is set up exactly like sheet1 except - I have ALL possible departments and ALL possible positions listed in Sheet2 (columnA). I need to set up a formula for each position in sheet2 telling excel to search for the match in sheet1 and return the corresponding hours worked and pay (as above). If a match is not found, then return zero. Does anyone know how to do this?

Sheet3
This is my journal entry. I can insert formulas that add up the amounts from sheet2 that correspond to each general ledger account.

Thank you so much for your help.