Automatic creation of summary and filling of data

I wish to know if this is possible:

1) Customer Orders flow in and Work Orders are allotted.
2) Each order has a different production schedule
3) When an order is recorded, it should automatically create the data in the Summary Sheet.

I attach a sample worksheet of what I wish to have. Can someone kindly tell me if such a thing is possible in Excel, please?