Automation of data entry

Good afternoon!

Remote work automates data entry into MS Excel. I'm the head of a wholesale food company.
During our work we have developed a certain scheme of work,
Which, due to the expansion of the company, requires some optimization.

Now our daily order is in the excel, which is filled as the
Orders from customers and sent out at completion
All interested persons, freight forwarders, storekeepers.
In case of dosing, an additional mailing is made.
And the problem is that we don't just ship from our warehouse.
We also sell them to suppliers on the day of shipment.


I am providing a working example of such an order.



Main requirements/wishes:

1. Setting up drop-down lists by customers, suppliers

2. Configuring the compliance of customers and suppliers to directions (example in the tab "data")

3. The table is kept weekly, every day - a new tab in the table, so
All functions must be saved when copying.

4. Setting the instant sort button by delivery directions.

5. Setting the instant sort button by collection directions

6. Ability to add data on customers/suppliers/directions, etc. without reprogramming
Tables

I am also interested in the possibility of further integration of such a table with 1C.
Thank you in advance for your answer.

vitaly