Extracting and comparing information from pivot table.

Hello experts, I have some data that I have created a report from. However it doesn't show a "true" picture for the stat we want. I have a pivot table set up with data showing the hours worked for an individual. What I am wanting to do would be to cross reference the data but not sure how to compare data. I have provided some make shift data to see if it is even feasible. The end goal is to get a true picture of P.P.H The data we are able to get is in a horrible format. I would eventually like to automate this in VBA but will work on the later. I thought about doing a vlookup but the is no real matching data for all employees. Some of the names are wrong in one system and there is no matching emp ID. Very disorganized. Anyways thoughts or suggestion on the best approach to tackle this project would be.

Some additional Info. There are 3 main tasks. Packing Picking and Pulling. The only way I have to distinguish between the 3 is filtering by keyword. It is multiple systems producing the reports that is why there is no common info between the three.

It stands for packages per hour. This whole change to the report is a pain unfortunately. I have the report in there that labels P.P.H It comes from a a report I make off of a massive CSV file and I have to break down the units into packages etc. That report only gives me hour long windows. In that hour long window though the person may work 40 minutes and switch job code. So the pivot table is basically just a way for me to organize the information. Each person is in the hours report 2-5 times depending on their department. I have a break down Packing Picking and Putting which tallies up total packages. What I am trying to do is use the information I put in the sample pivot chart where it matches their job, Packing, Picking, or has that divided into the total packages they had for that job code. I have a feeling this report is going to get scrapped until I am able to access SQL. There are 3 systems the company pulls from, all with their own databases, and they don't house a lot of the same information. I am basically making 1 report from 3 different reports. I apologize if the wording is confusing. I will give it some more thought after work. My main concern is the tool I created to extract the information from the CSV into excel, and corrupt the calculations I do with VBA.