Can I set up a workbook that multiple users update simultaneously without over typing each others?

The easiest way to do this is with Microsoft Forms in an Office 365 business environment. You set up the form to ask the questions as to what goes in each field. Multiple users can fill out the form simultaneously and it will populate your Excel file one record at a time and prevent any overlap. The users won't edit or open the file in Excel. Just you would to get the data out, or you could connect to it from another Excel or Power BI file via Power Query. Just point it to that table in that file. In that event, no one opens the file in Excel. It is just a database.