Inputting data from multiple instances from multiple users into a main Excel Workbook

Ok... maybe more data is needed since this has been avoided like the plaque... we have one central office and many satellite locations around the country... each location is responsible to go to tradeshows and enter their info and track not only tradeshow info, but tradeshow post reports and tradeshow check lists... I created a bunch of userforms that work together to handle the data entry and a bunch of code to make sure the data is entered correctly to normalize the data for reporting... after tons of coding and countless hours, I am happy to reprot this all works EXCELLENT!!!! Now here is the scratch.... I was thinking of giving each location a blank copy of the workbook and userforms (when launched, the workbook is hidden from users so they must enter data via the forms) and allowing them to input new data as well as edit update historical data as it gets populated... once they add a new record or edit an existing record, the workbook emails itself to a designated person in the main branch to put it in the main excel workbook that the others were cloned from... this would accomplish a couple things, ONE: the satellite locations will not see what the others are doing since they are only stewards of their own data (this is desirable) TWO: it would get past the issue excel has of multiple people having the excel book open for editing at the main branch.... this all is fairly straight forward I think... I figured out how to email the whole thing to a predetermined email once a command button is clicked... but not sure how to batch load it into the main excel workbook and then if and when I get this done, how to append new records and update existing data that might of changed.... any thoughts would be well received...
For sake of argument, I do not have Access and google spreadsheet might be a good choice but for now that is hindsight... I already have so much coding into this my wife is ready to divorce me for making her feel like a widow! lol

110 views without so much a thought
anyone, please?