- Transferring data from one excel to another
- Transfer data from one excel worksheet to another automatically - Guide
- How to transfer data from one excel workbook to another automatically using macro - Guide
- How to transfer data from one Excel sheet to another? - Guide
- Transfer data from one excel worksheet to another automatically with vba - Guide
- Transfer data from one excel file to another excel file ✓ - Forum - Excel
If master is not going to be available to individuals whose data you would be importing into master, I think one option that you can employ is have those individual dump data to a shared area/drive as CSV files. The master file can be coded on open to import all those csv files. You can have it programmed so that it goes thru every csv file and import the data and remove the csv once done. Only catch in this case would be to have a naming convention for csv files so that individual A does not over write individual B csv file.