update workbook in folder

[freezefiz]

hey everyone..

What i've got :
-protoV6.xls
-folder "PRODUCTION"

Well in protoV6.xls there's a "GrandTotal" sheet.
And this sheet will be saved as the 'date' in "PRODUCTION" folder.

12_Jun_2008.xls
	A	B	C	D
1	PrepareDate:	6/12/2008
2	Day:	Thursday
3	DeliverDate:
4	ProductID	Product	Uom	Qty
5	RFG-**508	CaliforniaTuna	PKT	6
6	RFG-**508	CaliforniaTuna	PCS	2
7	RFG-**501	RoastMexicanChicken	PKT	2
8	RFG-**501	RoastMexicanChicken	KG	2
9	RFG-**511	ChickenBolognaise	KG	7
10
11
12	handoverby:
13	receivedby:
Sheet1

If I have protoV7.xls, protoV8.xls(and more) & each has "GrandTotal" sheet, and i'd like to save it as an already existed workbook in "PRODUCTION", how do i UPDATE it instead of replacing it???

Pls Advise.

 

[freezefiz]

Oh and the qty col is using sumproduct.

issit possible to sum up all the new orders instead of overwriting?