Hello,

I have multiple vendors that sell a list of products.

I send each vendor a spreadsheet to update their list of products on a weekly basis (fields are product#, price, quantity). The vendors might add, delete or modify rows.

I would like a master spreadsheets that lists all products from multiple vendors. Can I link multiple vendor spreadsheets to one spreadsheet to give me one comprehensive list (without copying and pasting each week)?

Thanks