Create 'parent' table to update data in 'child' worksheets + data in 'child' worksheets must tally

I guess a database web application with login is suitable for Similar situation as below:

Due to various reasons, the customer's delivery date needs to be advanced or postponed. Every month, when making the production plan, the planner needs to inquire with the sales department about the adjusted delivery dates for all orders. If the planner sends the master sheet via email for each sales person to fill out, data leakage between different personnel may occur. Alternatively, the planner can send individual sheets to each sales person, but this results in multiple emails being sent and then merged into a master sheet. This process is time-consuming and labor-intensive.

Currently available conditions:

Each sales person has a fixed notebook login username.

There is a shared network file folder within the company.

The planner sets up a shared folder in the shared drive and shares the master sheet, setting read/write permissions for each sales person.

What is desired:

Each sales person logs into the shared network folder and opens the shared spreadsheet.

They can only see the content under their own name in the sheet.

They can only edit the adjusted delivery date column; the rest of the sheet's content is protected and only viewable.