Retrieving Data from a report using matching/lookup/indexing/something else?

Hi Everyone,

I am trying to find a way to automatically pull data from a payroll report over to a summary and calculation sheet. The report generates like the attached image. Basically I would like to be able to find Employee A (and/or department amounts) and pull over things like total pay, social security amount, total contributions excreta. The number of rows associated with each employee may change as may the number of employees, excreta. Thus, I would like to use a lookup of some sort or something similar. However, I am not sure the best way to do this as the data in multiple rows refers to each person and the report may not have the same items each month.

Does anyone know a good way to accomplish this?

Thanks in advance!

PR example table.JPG

Hi,

I know the old saying is "A picture is worth a thousand words", but not in this case. Recommend you upload a sanitized "working sample" copy. That would enable someone to provide a possible process to achieve what you are looking for.
Also I think the term you are wanting to use is "et cetera".

Cheers