Copy and paste the most recent entered data from other worksheets to summary sheet

Hi
I have a requirment for automating my routine tasks in excel. Here it is.

In the attached spreadsheet, whenever I run the macro in summary sheet, it should automatically look for the data in cell 2A, 2B and 2C of summary sheet, (2A gives the engineer name, and I have worksheets named after each engineer name) then go to that work sheet based on the value that matches to the value extracted from cell 2A, and then perform combined filter in that worksheet using the values that is obtained from cell 2B and 2C as criterias, and then copy the last row data but from column C to M (i,e Rev to General Status Comments Column). Now paste the copied data into summary sheets in the same column C to M and against the corresponding part number and document type. Repeat this process for all the engineer names, part numbers and document type that is listed in column A, B & C of summary sheet until it find empty data in column A of summary sheet.

Basically, I am trying to copy the most recent data/status of each part number and document type from the corresponding worksheet of engineer.

It would be a great help to me if someone shares a macro to automate this routine manual task. Attached my excel sheet that has sample data.

Thanks in advance,
Srini