- Transferring data from one excel to another
- Transfer data from one excel worksheet to another automatically - Guide
- Excel date format dd.mm.yyyy - Guide
- Vba code to search data in excel - Guide
- How to take screenshot in excel - Guide
- Number to words in excel without vba - Guide
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.