merging multiple excel worksheet into 1 worksheet

I have 8 testers out in verious locations in Pennsylvania. The are all using the attatched worksheet. After the testing they email them back to me. Is there a way of combining all 8 worksheets into one worksheet that can be edited? Or, make a database that can be edited. I am using Microsoft Office 2007

Thank you so much

Jim

I have 8 people doing testing through-out the state using the attached file. Is there a way to combine the excel files they email me into 1 editable file or database for a weekly report? These are slsm files that have alot of commands and calculations in them. I am using Microsoft Office 2007. Thank you very much.

Jim