I'm currently preparing a shared database in excel but I'm having some problems.

My goal is to have some fields that a group of users will fill (lets say gym members); in the end of the month I want to be able to compile all the information and have the details of the new member of the several gyms (about 3 hundreds).

I'm using Excel 2003 so I tried using lists shared in a windows shared workspace but in this case I can't have validation rules. I want to make the form (list, workbook, ...) inviolable. do you have any hint that can help me solve my problem?