Excel data parse

We receive a settlement sheet for services we provide to FedEx Ground on excel; we need to parse it to a different excel sheet for our payroll processing, 16 employees sorted by employee id. Repeats weekly.
Fairly simple.
Source GF_STATEMENT - Target Weekly Time Sheet
All data is proprietary to our company; we comply with Freelancer code of conduct.