Sharing workbook with multiple users

Hi Guys

I have a workbook that needs to be shared amongst 6 users.

Each user will need to select info from drop down boxes, however if for example, two users are on the same row selecting information, excel will save the last changes. Is there a way to overcome this?