collection data across multiple sheets based on match different structure

[abdo meghari]

hi

I would merge duplicate items and summing data but the sheets are not the same structure .some sheets contain the item in column B and the others in column B,C,D so it should match the items in all sheets between column B and columns B,C,D if they are matched then should merge and summing the quantity , if they are not matched should consider new items with summing the quantity . with considering should ignore the different space .
the result should be in sheet summary with update data every time add new data or change in all sheets .

FIND .xlsm
	A	B	C
1	ITEM	BRAND	QTY
2	1	BS LT285/75R16 AT001 JAP	100
3	2	BS 1200R20 G580 TC THI	30
4	3	BS 1200R24 20PR G582 JAP	40
5	4	BS 13R22.5 R187 JAP	50
6	5	BS 1400R20 VSJ JAP	120
7	6	BS 155R12C T R623 INDO	20
8	7	BS 165R13C R624 INDO	30
9	8	BS 175/70R13 EP150 INDO	120
10	9	BS 20.5R25** 2RR VUT IND	200
11	10	315/80R22.5 18PR R184 JAP	120
Sheet1

FIND .xlsm
	A	B	C	D	E
1	ITEM	BRAND	TYPE	ORIGIN	QTY
2	1	BS 1200R20 18PR	G580 TCF	JAP	200
3	2	BS 1200R20	G580 TC	THI	120
4	3	BS 1800R25**	VKT	JAP	120
5	4	BS 20.5R25** 2RR	VUT	IND	130
6	5	BS 1600-25 28PR	RLS	JAP	140
7	6	BS 1200R24 20PR	G582	JAP	150
8	7	BS 13R22.5	R187	JAP	300
9	8	BS 1400R20	VSJ	JAP	120
10	9	BS 155R12C T	R623	INDO	200
11	10	BS 165R13C	R624	INDO	250
12	11	BS 175/70R13	EP150	INDO	100
13	12	BS 175/70R14	EP150	THI	110
14	13	BS LT285/75R16	AT001	JAP	150
Sheet2

FIND .xlsm
	A	B	C
1	ITEM	BRAND	QTY
2	1	BS 1200R20 18PR G580 TCF JAP	20
3	2	BS 13R22.5 R187 JAP	50
4	4	BS 1200R20 G580 TC THI	30
5	5	BS 1200R24 20PR G582 JAP	40
6	6	BS 155R12C T R623 INDO	20
7	7	BS 165R13C R624 INDO	30
8	8	BS 175/70R13 EP150 INDO	20
9	9	BS 175/70R14 EP150 THI	12
10	10	BS 1800R25** VKT JAP	10
11	11	BS 20.5R25** 2RR VUT IND	200
12	12	BS 1600-25 28PR RLS JAP	150
sheet3

FIND .xlsm
	A	B	C	D	E
1	ITEM	BRAND	TYPE	ORIGIN	QTY
2	2	BS 1200R20	G580 TC	THI	120
3	1	BS 1200R20 18PR	G580 TCF	JAP	200
4	3	BS 1200R24 20PR	G582	JAP	150
5	4	BS 13R22.5	R187	JAP	300
6	5	BS 1400R20	R180	JAP	120
7	6	315/80R22.5 18PR	R184	THI	200
8
sheet4

the result

FIND .xlsm
	A	B	C	D	E
1	ITEM	BRAND	TYPE	ORIGIN	QTY
2	1	BS 1200R20 18PR	G580 TCF	JAP	420
3	2	BS 1200R20	G580 TC	THI	300
4	3	BS 1200R24 20PR	G582	JAP	380
5	4	BS 13R22.5	R187	JAP	700
6	5	BS 1400R20	VSJ	JAP	240
7	6	BS 1400R20	R180	JAP	120
8	7	BS 155R12C T	R623	INDO	240
9	8	BS 165R13C	R624	INDO	310
10	9	BS 175/70R13	EP150	INDO	240
11	10	BS 175/70R14	EP150	THI	122
12	11	BS 1800R25**	VKT	JAP	130
13	12	BS 20.5R25** 2RR	VUT	IND	530
14	13	BS 1600-25 28PR	RLS	JAP	290
15	14	BS LT285/75R16	AT001	JAP	250
16	15	315/80R22.5 18PR	R184	JAP	120
17	16	315/80R22.5 18PR	R184	THI	200
summary

thanks in advance

 

[abdo meghari]