Optimizing data entry in Excel file on SharePoint w/ 5 users: Is MS Forms + Power Automate the way?

I want to optimize data entry for an Excel spreadsheet stored on SharePoint, used by 5 data enterers. It has around 300 entries/rows and 17 columns on the main worksheet. 4 other worksheets contain additional variables/columns for the same entries on the main worksheet. 8 other worksheets contain extensive instructions for the systematic literature review we are conducting.

Edit: Our current approach has each of us open the Excel file in our desk top app for data entry.

The issues I want to solve are:

• Improved data entry environment: 1) Some cells end up with extensive/long text entries. Users resize cells to optimize their view, but that screws up other people's views. We need data entry solution that allows large data entry areas for certain Excel cells, but not others. 2) Decrease users mistakenly entering data in wrong cell.
• formatting issues caused by each user doing their own rogue formatting (Despite discussing not messing with formatting in couple of meetings, these people, led by our boss, keep doing it!)
• excel sheet freezing for short periods of time
• mouse pointer highlighting cells above the cell to which it is pointing

A bit of Googling led me to MS Forms + Power Automate. Would this solve the issues described above and be stable.

Is there a better solution?

Background Info

• I'm an intermediate/advanced excel user with experience in VBA, SQL, and stats packages (eg, SAS) working at a large federal agency
• Excel version: MS 365 MSO v2603
• We have MS Forms and Power Automate in-house