Vlookup vs Direct Cell Reference

[Anfinsen]

Good Morning All,

I have a master inventory worksheet, with 5,000 rows of data.
These 5,000 rows are split into 10 workbooks, with the exact same data, 500 rows per sheet.
All 11 (the master and 10 slit books) of these files are saved in the same folder. Of the 10 split workbooks, different people will work on them, and they save quite frequently.

On the master inventory sheet, what is the best way to pull info entered on the 10 split up books, back into the master sheet for the corresponding records?
I have tried both Vlookups and direct cell references, but they both seem clunky, I was curious if anyone had a more elegant way to accomplish this task?

Thanks in advance for your help!

 

[jkpieterse]

I suggest to use Data, Get Data, From File, From Folder.

 

[alansidman]

Since your are using 365, you have Power Query built in to append the 10 sheets to the Master.

How to Combine Tables with Power Query - Excel Campus

Use Power Query to combine similar tables together and append new ones. Easily change or delete the query as tables change

www.excelcampus.com