create a form for sales, finance and shipping that would be linked together

Basically the we have an online store and we we would need to do the following: (those forms for the seller not for customers) 1-we need to create forms that they would be filled out daily with the information of each client... such as Name: , Method of Payment, Order #.....etc so all of the information regarding any sale /order is entered manually. then they would need another form for the shipping department.. So for example , Order # 1111 is (filled out through the sales form and the status become confirmed---- confirmed means paid ..... it would automatically inform the shipping department to prepare the shipment for that particular order # 1111 ...Also at the same time the customer would receive SMS confirmation of the Tracking # once the it is shipped. (This integration would be taken from the filled out information in the shipping (Such as Name, Mobile #... and The Tracking #. (Everything is entered manually including the status of the order.) to sum up, once the status changes to confirmed by the sales (orders) , it would give an access to the Accounting department to verify the payment and provide reference number from the bank, and once again the status gets confirmed from the accounting, it would give the shipping department an access to update and prepare the shipment..... (like 3 forms the are linked together by the order #)so everything is filled out manually but when the status changes (to confirmed) it would automatically inform the other department of that so they can complete processing the order ... lastly, and lastly, They need a simple automated analysis of the whole process (for example, grouping all confirmed orders together , all shipped together and so on.... that could be presented in Charts , or any visual way of doing the overall Analysis or Report of all orders... attached is a picture of this