Building a CRM based on Google Sheets. Can someone help with the format and formulas?

Question

Google Sheets

Hello everyone,
I've encountered a problem of data exchange between tables.
I have a group of sites related to transportation. Leads are constantly falling for us and we transfer them to the table to managers.
I would like to automate the process.
There is a main table where we transfer all leads for control.
It would be desirable to construct dependence between tables.
There are several options:
1. This is a transfer from the main table where all the leads are, to the table to the manager and receive updates on status changes
2. This is to take data from the manager's tables and simply change the values ​​in the necessary columns
Example:

I'm waiting for advice and help.
The desire to understand the maximum

Answer 1

Good afternoon.
Ready to help you for a fee.
Briefly about myself:
I am engaged in business automation using Google “tools” (www.diskant.com.ua). To date, more than 30 projects have been implemented in various fields of activity: real estate agencies, online stores, trading, manufacturing, management companies, etc.
Ukraine, Kiev.