Hello, I am in a brainstorming phase and looking for the best way to link multiple Excel files, about 25 spreadsheets, into one master file, within Microsoft OneDrive. Each file will contain unique records, about 20 each, that are then each added to the master file as one list. This equates to a total of about 500 records on the master file. When a record is updated or added on any of the 25 files, the master file should update as well.

The thought so far is to link each file (of the 25) to a tab on the master file, that will update in real time. When a refresh of the master file is needed, the idea is to run a macro that takes the records from each of the 25 tabs to compile them into one list, which is VBA code we already have built.

I have to believe there are other or better ways to do this, and hoping to brainstorm with an Excel / OneDrive community. Welcome and appreciate any thoughts. Thanks in advance.

Sheryl