move values over the other ,summing from multiple sheets and split new

[abdo meghari]

Hi
I want match the items are existed in column B for sheets(BUYING,REPR,SELLING) with columns D:F and should autofill & summing the values the column C for sheet BUYING, REPR should be summing also with column D and put the final value after summing into column G for sheet REPORT and sum the values for columns D for sheets REPR,SELLING and put the final values after summing into column H for sheet REPORT. as to column I should subtract values into column G from column H.
and if there are new items for sheets (BUYING,REPR,SELLING) then should split the item based on three digits contain two first item, second , three) as highlighted by red and the others items are splitted .
I have about 4600 rows for each sheet and will increase . just a little data to understand me

REPORT.xlsm
	A	B	C
1	ITEM	BRAND	QTY
2	1	DT 315/80R22 R184 THI	10
3	2	BS 195R15C R623 THI	300
4	3	FS 195R15C R623 JAP	500
5	4	BS 315/80R22 R184 JAP	100
6	5	BS 1200R24 G580 THI	200
7	6	BS 1200R20 G580 JAP	120
8	7	BS1400R20 R180 JAP	20
9	8	BS 1400R20 R180BZ JAP	10
10	9	BS11R22.5 R187 JAP	22
11	10	DT 12R22.5 R187 JAP	5
12	11	DT 12R22.5 R187 THI	6
BUYING

REPORT.xlsm
	A	B	C	D
1	ITEM	BRAND	PURCHASE	SELLING
2	1	BS 1400R20 R180BZ JAP	100	10
3	2	BS11R22.5 R187 JAP	22
4	3	DT 12R22.5 R187 JAP	11
5	4	DT 12R22.5 R187 THI	10	1
6	5	BS 1200R20 G580 JAP	120	10
7	6	BS 1200R20 G580 THI	300
REPR

REPORT.xlsm
	A	B	C	D
1	ITEM	BRAND	SALE	ARRIVE
2	1	DT 315/80R22 R184 THI	10
3	2	BS 195R15C R623 THI	300	4
4	3	FS 195R15C R623 JAP	500
5	4	BS 315/80R22 R184 JAP	100
6	5	BS 1200R20 G580 JAP	10	6
7	6	BS 1200R24 G580 THI	200
8	7	BS 1400R20 VSJ JAP		4
9	8	BS 385/65R22.5 R164 JAP	10
SELLING

REPORT.xlsm
	C	D	E	F	G	H	I
1	ITEM	BRAND	TYPE	TYPE	ARRIVE	SALE	BALANCE
2	1	BS 1200R20	G580	JAP
3	2	BS 1200R20	G580	THI
4	3	BS 1200R24	G580	THI
5	4	BS 195R15C	R623	THI
6	5	FS 195R15C	R623	JAP
7	6	BS 315/80R22	R184	JAP
8	7	DT 315/80R22	R184	THI
9	8	BS11R22.5	R187	JAP
10	9	DT 12R22.5	R187	JAP
11	10	DT 12R22.5	R187	THI
report

result

REPORT.xlsm
	M	N	O	P	Q	R	S
1	ITEM	BRAND	TYPE	TYPE	ARRIVE	SALE	BALANCE
2	1	BS 1200R20	G580	JAP	246	16	230
3	2	BS 1200R20	G580	THI	300	200	100
4	3	BS 1200R24	G580	THI	400		400
5	4	BS 1400R20	VSJ	JAP	4		4
6	5	BS1400R20	R180	JAP	20
7	6	BS 1400R20	R180BZ	JAP	110	10	100
8	7	BS 195R15C	R623	THI	600	4	596
9	8	FS 195R15C	R623	JAP	1000		1000
10	9	BS 315/80R22	R184	JAP	200
11	10	DT 315/80R22	R184	THI	20
12	11	BS 315/80R22	R152	JAP
13	12	BS 385/65R22.5	R164	JAP		10	-10
14	13	BS11R22.5	R187	JAP	44		44
15	14	DT 12R22.5	R187	JAP	16		16
16	15	DT 12R22.5	R187	THI	16	1	16
report

 

[abdo meghari]

there is error in result for the range about last picture.
this is right

REPORT.xlsm
	C	D	E	F	G	H	I
1	ITEM	BRAND	TYPE	TYPE	ARRIVE	SALE	BALANCE
2	1	BS 1200R20	G580	JAP	246	16	230
3	2	BS 1200R20	G580	THI	300	200	100
4	3	BS 1200R24	G580	THI	400		400
5	4	BS 1400R20	VSJ	JAP	4		4
6	5	BS1400R20	R180	JAP	20
7	6	BS 1400R20	R180BZ	JAP	110	10	100
8	7	BS 195R15C	R623	THI	600	4	596
9	8	FS 195R15C	R623	JAP	1000		1000
10	9	BS 315/80R22	R184	JAP	200
11	10	DT 315/80R22	R184	THI	20
12	11	BS 315/80R22	R152	JAP
13	12	BS 385/65R22.5	R164	JAP		10	-10
14	13	BS11R22.5	R187	JAP	44		44
15	14	DT 12R22.5	R187	JAP	16		16
16	15	DT 12R22.5	R187	THI	16	1	16
report