Combine info from multiple spreadsheets that auto fill

I have an excel sheet that uploads barcode scans that I would like to combine with data from an existing spreadsheet based on the barcode number.

Basically the scans will provide observational data, and I want to link that data based on existing identifying information.