multiple users

I have multiple users entering data in excel. Thier information is the same, ie, each row has the same information, but I would like to combine all this data into one worksheet. Automated of course. I know how to move data, but don't know how to have it automatically fill the one worksheet as the employee is filling out their own worksheet. It would be better if this could be done on seperate files so they could input at the same time, don't know if this is possible either. Any help would be appreciated.

Mapper