Matching data in multiple excel documents

[Hs97]

Is there a flow I could process to match data that is in the same format between different excel books. 

For example, I have a file that contains all the data and I want to match it to each individual excel document to ensure the data is accurate 

Example:

Joint workbook 

 

Separate Excel Documents

   

Desired output

 

[atcodedog05]

Hi @Hs97 

can you provide the input excel file.