How sum values for multiple columns based on headers across sheets except the others

[Maklil]

HI

the result should be in columns G,H in sheet summary after matching the headers COST TOTAL , SALES TOTAL for each item based on column B . so what I want to match the headers for each item just for three sheets SH,PTT,PMT ,then should sum the values are existed in column COST TOTAL for sheets SH,PTT,and the sum the values are existed in column SALES TOTAL for sheets SH,PMT with considering if there is duplicates items for three sheets should merge for instance HR2002 =21,600+21,600+21,450=64650 for cost total , the same thing for column sales total .as to sheets PVT,PMM if there are new items are not existed in sheets SH,PTT,PMT then should also add it with merge duplicates items . I have about 7500 rows across sheets

sum.xlsm
	A	B	C	D	E	F	G	H	I	J
1	ITEM	CODE	BRAND	MIN	TBR	QTY	COST	SALES	COST TOTAL	SALES TOTAL
2	1	HR2000	CR/MM-1	CCN	TYI	200.00	KWD 123.00	KWD 133.00	KWD 24,600.00	KWD 26,600.00
3	2	HR2001	CR/MM-1	CCN	TRY	250.00	KWD 122.00	KWD 133.00	KWD 30,500.00	KWD 33,250.00
4	3	HR2002	CR/MM-1	CCN	TRE	150.00	KWD 144.00	KWD 150.00	KWD 21,600.00	KWD 22,500.00
5	4	HR2003	CR/MM-2	CCN	TRE	200.00	KWD 145.00	KWD 160.00	KWD 29,000.00	KWD 32,000.00
SH

Cell Formulas
Range	Formula
I2:I5	I2	=G2*F2
J2:J5	J2	=H2*F2

sum.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	MIN	TBR	QTY	COST	COST TOTAL
2	1	HR2000	CR/MM-1	CCN	TYI	200.00	KWD 123.00	KWD 24,600.00
3	2	HR2001	CR/MM-1	CCN	TRY	250.00	KWD 122.00	KWD 30,500.00
4	3	HR2002	CR/MM-1	CCN	TRE	150.00	KWD 144.00	KWD 21,600.00
5	4	HR2003	CR/MM-2	CCN	TRE	200.00	KWD 145.00	KWD 29,000.00
6	5	HR2001	CR/MM-1	CCN	TRY	250.00	KWD 123.00	KWD 30,750.00
7	6	HR2004	CR/MM-2	CCN	TREI	200.00	KWD 145.00	KWD 29,000.00
8	7	HR2004	CR/MM-2	CCN	TREI	200.00	KWD 146.00	KWD 29,200.00
9	8	HR2002	CR/MM-1	CCN	TRE	150.00	KWD 143.00	KWD 21,450.00
PTT

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

sum.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	MIN	TBR	QTY	SALES	SALES TOTAL
2	1	HR2002	CR/MM-1	CCN	TRE	KWD 150.00	KWD 144.00	KWD 21,600.00
3	2	HR2003	CR/MM-2	CCN	TRE	KWD 200.00	KWD 145.00	KWD 29,000.00
4	3	HR2004	CR/MM-2	CCN	TREI	KWD 200.00	KWD 147.00	KWD 29,400.00
5	4	HR2000	CR/MM-1	CCN	TYI	KWD 200.00	KWD 123.00	KWD 24,600.00
6	5	HR2001	CR/MM-1	CCN	TRY	KWD 250.00	KWD 122.00	KWD 30,500.00
7	6	HR2004	CR/MM-2	CCN	TREI	KWD 200.00	KWD 148.00	KWD 29,600.00
8	7	HR2003	CR/MM-2	CCN	TRE	KWD 200.00	KWD 145.00	KWD 29,000.00
PMT

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

sum.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	MIN	TBR	QTY	COST	COST TOTAL
2	1	HR2000	CR/MM-1	CCN	TYI	KWD 200.00	KWD 133.00	KWD 26,600.00
3	2	HR2001	CR/MM-1	CCN	TRY	KWD 250.00	KWD 133.00	KWD 33,250.00
4	3	HR2002	CR/MM-1	CCN	TRE	KWD 150.00	KWD 150.00	KWD 22,500.00
5	4	HR2003	CR/MM-2	CCN	TREQ	KWD 200.00	KWD 160.00	KWD 32,000.00
6	5	HR2004	CR/MM-3	CCN	TREM	KWD 200.00	KWD 161.00	KWD 32,200.00
7	6	HR2005	CR/MM-4	CCN	TR	KWD 200.00	KWD 162.00	KWD 32,400.00
8	7	HR2005	CR/MM-4	CCN	TR	KWD 200.00	KWD 163.00	KWD 32,600.00
PVT

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

sum.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	MIN	TBR	QTY	SALES	SALES TOTAL
2	1	HR2000	CR/MM-1	CCN	TYI	KWD 200.00	KWD 123.00	KWD 24,600.00
3	2	HR20011	CR/MM-1	CCN	TRAS	KWD 250.00	KWD 123.00	KWD 30,750.00
4	3	HR20011	CR/MM-2	CCN	TRAS	KWD 251.00	KWD 124.00	KWD 31,124.00
5	4	HR2005	CR/MM-4	CCN	TR	KWD 200.00	KWD 166.00	KWD 33,200.00
6	5	HR2005	CR/MM-4	CCN	TR	KWD 200.00	KWD 166.00	KWD 33,200.00
PMM

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

sum.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	MIN	TBR	QTY	COST TOTAL	SALES TOTAL
2	1	HR2000	CR/MM-1	CCN	TYI	234.00
3	2	HR2001	CR/MM-1	CCN	TRY	300.00
4	3	HR2002	CR/MM-1	CCN	TRE	450.00
5	4	HR2003	CR/MM-2	CCN	TRE	2,344.00
6	5	HR2004	CR/MM-2	CCN	TREI	245.00
7	6	HR2005	CR/MM-4	CCN	TR	340.00
8	7	HR20011	CR/MM-2	CCN	TRAS	400
SUMMARY

result

sum.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	CODE	BRAND	MIN	TBR	QTY	COST TOTAL	SALES TOTAL
2	1	HR2000	CR/MM-1	CCN	TYI	234.00	KWD 49,200.00	KWD 51,200.00
3	2	HR2001	CR/MM-1	CCN	TRY	300.00	KWD 91,750.00	KWD 63,750.00
4	3	HR2002	CR/MM-1	CCN	TRE	450.00	KWD 64,650.00	KWD 44,100.00
5	4	HR2003	CR/MM-2	CCN	TRE	2,344.00	KWD 58,000.00	KWD 116,000.00
6	5	HR2004	CR/MM-2	CCN	TREI	245.00	KWD 58,200.00	KWD 59,000.00
7	6	HR2005	CR/MM-4	CCN	TR	340.00	KWD 65,000.00	KWD 66,400.00
8	7	HR20011	CR/MM-2	CCN	TRAS	400		KWD 61,874.00
SUMMARY

I hope some body help