I encourage you to record a macro doing all of that, then reverse engineer the variables, and attach a button! It is that simple :)
If I had to this, I would be using a DATABASE. With a database, you can build triggers, and make the tables keep track of each other!
Then just build a report, to get your orders, the order destination and all kind of good stuff (that you can't do in a spreadsheet!)