Excel people, my heroes...

I have a fantastic purchase order form i've been working on for a week now, i love it!

It looks just like the old paper version
It fits exactly on an A4 page
It emails great
It faxs great
It calls up all existing placed orders
All partially recieved orders, all completly recieved orders
All draft orders


But when i save an order to do any of the above, it saves the main sheet, renames it to OrderNumber###.xls, removes some sheets and functionality that should only be present in the main purchase order sheet, and works fine.

But it's still over 100k per saved order.
Although they're then saved, and easy to open again and reprint/fax etc..

I'm thinking it's not the most efficient way of saving them, especially if we have a few thousand orders per year!

So, i'm after any ideas to help me get my head around this.
Is it possible for a macro to take certain cells and save the value into another workbook?
And then of course, be able to repopulate the main template using data from this other workbook?
That way, every order needed to be saved would would only require a row in a workbook instead of 100k



Possible? Much work?