Hey Scott,

How about another idea here. What if each person had their own workbook with a single sheet, where they add data. Then you put all their workbooks into a single directory/folder and append all of them to a single workbook. This is a new feature in Excel 365 called Get & Transform. No VBA needed.

http://excelunplugged.com/2015/02/10...n-power-query/
https://support.office.com/en-us/art...8-6a00041c90e4

The beauty of this is you can have more and more people add files to the folder and simply run the PQ again and it will gather up all those files into a single master.