Multiple sheets updating one Master

I am almost done with the programming on this sheet, and this site has been so so helpful, but i have one last final problem. Each person in my office will have a copy of the sheet attached to this post, located on their desktop. What i need to happen is when they hit close on the Main menu, it will automatically send the information to a master sheet, then close the workbook. the master sheet will be reviewed by the managers for accuracy.

For one, I'm not even sure how I would need to code this. Second, I know that, because Sheet 4(labeled as sheet1) will be protected, will that affect saving the information onto another workbook? And, the third, if possible, I would like the managers to be able to edit the information that comes in from multiple sheets, and have that update the corresponding sheet.

I understand that the last part may not be possible, but if it is, it would help greatly.

the username to use is tester, and the password is test01