Can someone tell me the best way to list data that comes from two seperate
files?

Example: I have two files
1) A Plant & Store master excel file (list all store numbers and the plant)
2) Another excel file that list store numbers and a store score.

Would like to create a third file/report that shows the plant, store number,
and score (and ensure the master file poplulates the report plant & store
number). This report would be updated from the original two files (they get
saved quarterly so want this report updated automatically).

Thanks for any suggestions.