Identifying non-pulled data from Vlookups

Good afternoon everyone and thanks in advance for your help!

I have a master file that lists a variety of data and requires updating from various reference reports. Every month, reference reports detail activity (Revenue) that is processed for most of the existing rows on the master file (previously listed Jobs) in addition to activity for new rows (New Jobs) that are not listed in the master file.

I know I can execute a Vlookup to look up the activity for the existing job, but I still need to comb through the data to see which jobs need to be added to the master file. Is there a function that will note which row from the reference sheet were not pulled and therefore should be added to the master file?

Sorry in advance if previously posted.

Ryan