Excel to excel data parse

We receive a settlement sheet on excel and pdf, need to parse it to a different excel sheet for payroll processing, 16-18 employees by employee id. repeats weekly.
Source GF_STATEMENT Target Weekly Time Sheet