Now my question is, can you setup a spot that each person can use the same spreadsheet or the same access database? Access would be a nice option, very flexible and easy to creat any kind of report that your client might need. But it would require that each person be able to use the same database. This can be done either through a share or maybe create a website where they can log in and enter the information.
You don't NEED to access the same file, thought it is nice. You can look into importing data from one access database into another, or look into mergeing in excel. All depends on how each person can access the files.
Post here or email/PM me if you want more details or may need some help on this. I will reply as quickly as I can. I have classes all next week but will reply when I get home.