Update cell values in master file if changes were made in update file

I have a file which is comprised of 4 different sheets
(1) FullFile; contains ~40,000 records
(2) RR-1; research report 1
(3) RR-2; research report 2
(4) RR-2; research report 3

The research reports tabs contain updated information for records in the FullFile. For each record in each research report, I want to update the FullFile with the updated information. I was going to do something where for each record in FullFile, look to see if records exists in research report 1, 2, and 3. If record found, then update fields accordingly, else (not found) do nothing. The issue with this is the processing time is going to take a long time to complete. Is there a more efficient way to accomplish this? I have attached small sample file if needed.

An example of an update in the file would be for record number 42, for example. Record number 42 is the first record in research report 1. Once a record is located in any research report, I need to update all three fields lastname, firstname, and mailing address in the FullFile. Thanks