Merging columns, excluding columns, and calculating columns by division over another across sheets

[Alaa mg]

hi
I would like macro to merge a group of columns from the other sheets In STTO sheet, the values shown in column F will be the summation of values for the same column (F) from the second and third sheets . As for column (G) , the summing process will just be from the fourth sheet of column( F). As for column (J), the summing process will be done from the second sheet for column( I) and third sheet for columns (H).As for column K, the collection process will take place from the second sheet for column (J) and fourth sheet for column (H). After doing all these steps, the values of the two columns(H,I) in sheet STTO will be extracted by dividing the columns by each other. I have put the formulas into them . so that the extraction method is done, but I do not want any formula in the output STTO sheet .
when run the macro should clear data from before brings data to update any changing , and just I want brings data without formatting (I will do that manually to avoid code slowness)
last thing if the macro could deal with 8000 rows will be great .
I hope there is no error and very clear .

CMM.xlsm
	A	B	C	D	E	F	G	H	I	J
1	DATE	REF	DEL	NTP	ORTR	QTY	P PURCHASE	P SELLING	T PURCHAE	T SELLING
2	01/01/2010	AA123	ASD-12	VV-1	TT	300	100.00	200.00	30,000.00	60,000.00
3	02/01/2010	AA123	ASD-12	VV-1	TT	200	200.00	150.00	40,000.00	30,000.00
4	03/01/2010	AA123	ASD-12	VV-1	TT	250	120.00	100.00	30,000.00	25,000.00
5	04/01/2010	AA123	ASD-12	VV-1	TT	300	180.00	200.00	54,000.00	60,000.00
6	05/01/2010	AA123	ASD-12	VV-1	TT	120	250.00	80.00	30,000.00	9,600.00
7	06/01/2010	AA123	ASD-12	VV-1	TT	100	100.00	100.00	10,000.00	10,000.00
8	07/01/2010	AA124	ASD-13	VV-2	TT	600	110.00	300	66,000.00	180,000.00
9	08/01/2010	AA125	ASD-14	VV-3	TT	700	120.00	150	84,000.00	105000
10	09/01/2010	AA126	ASD-15	VV-4	TT	800	122.00	200	97,600.00	160000
11	10/01/2010	AA127	ASD-16	VV-5	TT	900	130.00	160	117,000.00	144,000.00
12	11/01/2010	AA124	ASD-13	VV-2	TT	300	80.00	100	24,000.00	30000
13	12/01/2010	AA125	ASD-14	VV-3	TT	120	90.00	70	10,800.00	8400
14	13/01/2010	AA124	ASD-13	VV-2	TT	200	120.00	110	24,000.00	22,000.00
15	14/01/2010	AA125	ASD-14	VV-3	TT	100	70.00	110	7,000.00	11000
16	15/01/2010	AA128	ASD-154	VV-41	WE	200	120.00	140	24,000.00	28000
ENTERING

Cell Formulas
Range	Formula
I2:I16	I2	=F2*G2
J2:J16	J2	=F2*H2

CMM.xlsm
	A	B	C	D	E	F	G	H
1	DATE	REF	DEL	NTP	ORTR	QTY	P PURCHASE	TOTAL
2	01/01/2011	AA123	ASD-12	VV-1	TT	10.00	120.00	1200
3	02/01/2011	AA123	ASD-12	VV-1	TT	10.00	100.00	1000
4	03/01/2011	AA123	ASD-12	VV-1	TT	10.00	110.00	1100
5	04/01/2011	AA123	ASD-12	VV-1	TT	10.00	200.00	2000
6	05/01/2011	AA123	ASD-12	VV-1	TT	10.00	110.00	1100
7	06/01/2011	AA123	ASD-12	VV-1	TT	10.00	80.00	800
8	07/01/2011	AA124	ASD-13	VV-2	TT	100.00	110.00	11000
BTY

Cell Formulas
Range	Formula
H2:H8	H2	=F2*G2

CMM.xlsm
	A	B	C	D	E	F	G	H
1	DATE	REF	DEL	NTP	ORTR	QTY	SELLING PRICE	T SELLING
2	01/01/2011	AA123	ASD-12	VV-1	TT	20	220.00	4400
3	02/01/2011	AA123	ASD-12	VV-1	TT	10	230.00	2300
4	03/01/2011	AA123	ASD-12	VV-1	TT	50	180.00	9000
5	04/01/2011	AA123	ASD-12	VV-1	TT	20	150.00	3000
6	05/01/2011	AA123	ASD-12	VV-1	TT	30	120.00	3600
7	06/01/2011	AA123	ASD-12	VV-1	TT	40	160.00	6400
8	07/01/2011	AA125	ASD-14	VV-3	TT	50	100	5000
9	08/01/2011	AA125	ASD-14	VV-3	TT	20	110	2200
10	09/01/2011	AA124	ASD-13	VV-2	TT	10	150	1500
11	10/01/2011	AA126	ASD-15	VV-4	TT	10	220	2200
12	11/01/2011	AA128	ASD-154	VV-41	WE	100	150.00	15000
13	12/01/2011	AA127	ASD-16	VV-5	TT	50	170.00	8500
STY

Cell Formulas
Range	Formula
H2:H13	H2	=F2*G2

result

CMM.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	ITEM	REF	DEL	NTP	ORTR	Q PURCHASE	Q SELLING	P PURCHASE	P SELLING	T PURCHASE	T SELLING
2	1	AA123	ASD-12	VV-1	TT	1330	170	151.2781955	1313.529412	201200	223300
3	2	AA124	ASD-13	VV-2	TT	1200	10	104.1666667	23350	125000	233500
4	3	AA125	ASD-14	VV-3	TT	920	70	110.6521739	1880	101800	131600
5	4	AA126	ASD-15	VV-4	TT	800	10	122	16220	97600	162200
6	5	AA127	ASD-16	VV-5	TT	900	50	130	2880	117000	144000
7	6	AA128	ASD-154	VV-41	WE	200	100	120	280	24000	28000
8
9
10
11
12
13
STTO

Cell Formulas
Range	Formula
H2:I7	H2	=J2/F2

 

[Alaa mg]

BTW: I have HOME sheet name in first sheet so becarfule the location others sheets in locations based on my explenation

 

[Alaa mg]

for instance AA123 will summing for two columns F for sheets ENTERING & BTY
so sheets ENTERING the total after summing =1270
sheets BTY the total after summing =60
so the column F in STTO =1270+60=1330
as to column F for sheet STY the total after summing =170
so the column G for sheet STTO= 170
sheets ENTERING the total for column I after summing =194000
sheets BTY the total for column H after summing =7200
so the column J in STTO =194000+7200=201200
sheets ENTERING the total for column J after summing =194600
sheets STY the total for column H after summing =28700
so the column K in STTO =194600+28700=223300
finally should extract values for columns H,I for sheet STTO by H=J/F & I=K/G
not always what show in ENTERING sheet should also be in sheet BTY .

 

[Alaa mg]

is there any help?

 

[Alaa mg]

no answering so far . I posted in this forum .
Merging columns, excluding columns, and calculating columns by division over another