Excel Inventory Management - Tough Project

Hi,

I have a project I have been trying to figure out. Basically we manage inventory from multiple vendors who all send their reports in different formats.
I want to have one master spread sheet with items #s from all vendors that can update from each vendors differently formatted report that they send.
I am not sure what the best option is here.

Maybe we can have one master folder with all 15 vendors reports, but how would the master sheet read those correctly?

If anyone can help that would be great!

Thank you,
Isaac

Are you limited to Excel 2007?

No I have Excel 2016

Maybe investigate Data -> Get & Transform as a way of linking to all the sources from one workbook.

Question is ambiguous without examples... what specific data are you trying to capture on your master spreadsheet, and how are the reports from the various vendors formatted differently? Can you upload a sample of each vendor's report format, and a dummy version of your master file with the data from the sample reports manually entered, to demonstrate your desired result?