With VBA
You need to work out:
: how to copy data from one sheet to another,
: how to locate the next blank row in a sheet
: how to update the order number cell
All the answers are on this forum and elsewhere via google.
I'll give you a start, to update the order number (if the order number is in cell B1 in sheet 1, the code would be -
sheets("sheet1").range("b1").value = sheets("sheet1").range("b1").value + 1
I could give you the whole thing, but trust me on this one, you'd be bette off learning it, it really isn't that difficult, and once you do you'll find that you can do far more than you originally thought.
Matt