Some suggestions...
I would say to consider employing a UserForm so you can control how the data is entered. Where the worksheet is protected and the only way the user could add data to the worksheet is through the UserForm.
Or a data entry sheet which you can with a macro transfer to the protected summary worksheet which contains each record added from the input sheet.