Hi,

You can Use Multiple Options to Solve This

Like:-

1. Using VBA Script
2. Using vlookup Formula
3. Using Java Code
4. Very Easy and Simple Tool Synkronizer. Using This Amazing Tool you can Easily Compare and Merge Multiple Files and Sheets.
https://www.synkronizer.com/