Merge 1000 items and 10000 rows for duplicates items from multiple columns

[abdo meghari]

Hi experts
I need merging column B,C,D into one column and sum value in column E for duplicates items .
the original data

SP.xlsm
	A	B	C	D	E
3	ITEM	BRAND	TYPE	ORIGIN	BALANCE
4	1	245/40R18	RE050A	JAP	36
5	2	245/40R20	RE050A	JAP	19
6	3	245/45R17	RE050A	JAP	15
7	4	245/45R17	EA01	JAP	1
8	5	245/45R19	S-03	JAP	7
9	6	245/40R20	RE050A	JAP	20
10	7	245/45R17	RE050A	JAP	22
11	8	245/65R17	D697	INDO	25
12	9	245/70R16	D694	JAP	3
13	10	245/70R16	D697	INDO	1
14	11	245/75R16	D697	INDO	12
15	12	245/75R17	693A	JAP	623
16	13	255/30R19	RE050A	JAP	12
17	14	255/35R18	GR90	JAP	14
18	15	255/35R20	RE050A	JAP	8
BMS

the result

SP.xlsm
	A	B	C
3	ITEM	BRAND	BALANCE
4	1	245/40R18 RE050A JAP	36
5	2	245/40R20 RE050A JAP	39
6	3	245/45R17 RE050A JAP	37
7	4	245/45R17 EA01 JAP	1
8	5	245/45R19 S-03 JAP	7
9	6	245/65R17 D697 INDO	25
10	7	245/70R16 D694 JAP	3
11	8	245/70R16 D697 INDO	1
12	9	245/75R16 D697 INDO	12
13	10	245/75R17 693A JAP	623
14	11	255/30R19 RE050A JAP	12
15	12	255/35R18 GR90 JAP	14
16	13	255/35R20 RE050A JAP	8
RESULT

and should update in result sheet based on updating BMS sheet when run the macro every time .
I have about 1000 items and could repeat for 10000 rows
thanks

 

[DanteAmor]

second I have question about sorting ,does sort this data are correct ?

I don't know, I understood that you want the data ordered from small to big,

can sort from small to big after merging please?

I suppose you mean column C, or do you want column B?
Or you want C and then alphabetize B.
But these are assumptions, you must be clearer in the requests, in fact in the original post you did not ask for the data to be sorted.

So if you are so kind, could you explain what data do you have and what is the end result you want?

 

[abdo meghari]

But these are assumptions, you must be clearer in the requests, in fact in the original post you did not ask for the data to be sorted.

sorry about it

I suppose you mean column C, or do you want column B?

sould be column B

So if you are so kind, could you explain what data do you have and what is the end result you want?

never mind , after your guiding I change C3 to B3
now sort as the excel does it manually
thank you & @kevin9999 , @alansidman for your assistance
have a nice weekend

 

[DanteAmor]

although I recommend you use the code provided by @DanteAmor in post #8 as it is more concise & efficient to what I provided.

Thank you Kevin for your kind comments.
Have a nice day.