Finalize the self-written crm (php, CodeIgniter framework)

The price is conditional, I do not know how much it costs, offer a price and terms.

There is a simple crm in which the cards of employees and customers are stored, and all other processes occur in google-tables. The general task is to ensure that under the current scale of the business there are no heaps of tables, and everything is stored in one place, the data is entered into crm and displayed there in the necessary tabs.

For example

1) There is a table "customers - support", from it make a tab.

Now the data is driven into this table with your hands, after which the copypaste from the table enters this data into the clients card in the CPM. I want everything that is in the table to be implemented in the CPM, the data to enter into the client card on the "Customers" tab, and then they would be pulled up in the necessary fields of the "Customer Support" tab inside the CPM.

2) Table "Remote Search Department", make a tab from it.

Same thing: anything in the google table would be inside the cpm.

3) Table "Sales department", make a tab from it.

To transfer the google-plate to the CPM according to some algorithm (we will develop together) would expose to each client a responsible employee, that is, the managers who are in the shift today would be distributed to customers.