I've searched everywhere but wasn't able to find anything that directly applied to what I'm needing to do.

The scenario - 10 Users all with identical userform workbooks for data entry. Each entry is marked with a unique identifier and saved into their own workbook. This data will also need to be entered into 2 Master files (one for archiving and the other for pulling data back into the form for editing). These Masters will be in different folders but I can try and figure this part out. When the information is added from their sheets to the Master files, the masters will (eventually) need the data to be entered in the first empty row. For the sake of ease, the titles of the Masters will be Master(Active) in file folders in the c-drive titled folder1 and Master(Archive) also in c-drive titled folder2.

If I've left any loose ends in my explanation, please let me know. I'm really desperate to finish this massive project up and this forum has provided me with 80%-90% of what's been accomplished.

I've attached a very basic form below. Thanks in advance for any help!

Save2Master (Build1).xlsm