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?