add missed digits,letters & symbols , bold and highlight for two sheets based on another

[Alaa mg]

hi
I have two sheets (sheet1,2) with different data structure . the sheet1 should match the column B with sheet MAIN into column B and add missed items into sheet1 . as to sheet2 should match columns B,C,D with sheet MAIN into column B and add missed items also should be bold and highligted by red for the missed items . and I want replace the data when add new data into two sheets(sheet1,2).
the data before
sheet MAIN

zz.xlsx
	B
1	brand
2	CC 2500M14 TT 11TM NN1 GER
3	CC 2500M14 13TM TN T123 GER
4	CC 2500M14 11TM T123 TN GER
5	CC 2500M14 11TM NN1 TT GER
6	BBW 1248-23 TL-ML 13TR NN IT
7	FG 12456TR40***** 22TM TT 1445V IT
8	DF 125/22MT23.5-22TM SL200 GER
9	MLC 111MR12L 12TM TD SV123 IT
10	NN 123/34T22.5-12MR SS1/1 NN GR
11	CC 2500M14 12TA T123 TN GER
MAIN

SHEET1

zz.xlsx
	B
1	BRAND
2	CC 2500M14 11TM NN1 GER
3	BBW 1248-23 TL-ML 13TR NN IT
4	FG 12456TR40***** 22TM 1445V IT
5	DF 125/22MT23.5 SL200 GER
6	MLC 111MR12L 12TM SV123 IT
7	NN 123/34T22.5 SS1/1 NN GR
8	CC 2500M14 11TM NN1 GER
9	CC 2500M14 T123 GER
10	CC 2500M14 11TM T123 GER
SHEET1

SHEET2

zz.xlsx
	B	C	D
1	BRAND	TY	OR
2	CC 2500M14 11TM	T123	GER
3	CC 2500M14 11TM	NN1	GER
4	BBW 1248-23 TL-ML 13TR	NN	IT
5	FG 12456TR40 1445V	22TM	IT
6	DF 125/22MT23.522TM ML-120	SL200	GER
7	MLC 111MR12L 12TM	SV123	IT
8	NN 123/34T22.512MR	SS1/1 NN	GER
9	CC 2500M14 11TM	NN1	GER
10	CC 2500M14	T123	GE
SHEET2

after
sheet1 based on sheet MAIN
[

zz.xlsx
	B
1	BRAND
2	CC 2500M14 TT 11TM NN1 GER
3	BBW 1248-23 TL-ML 13TR NN IT
4	FG 12456TR40***** 22TM TT 1445V IT
5	DF 125/22MT23.5-22TM SL200 GER
6	MLC 111MR12L 12TM TD SV123 IT
7	NN 123/34T22.5-12MR SS1/1 NN GR
8	CC 2500M14 13TM TN T123 GER
9	CC 2500M14 11TM T123 TN GER
10	CC 2500M14 11TM NN1 TT GER
SHEET1

sheet2 based on sheet MAIN

zz.xlsx
	B	C	D
1	BRAND	TY	OR
2	CC 2500M14 TT 11TM	NN1	GER
3	CC 2500M14 12TA	T123 TN	GER
4	BBW 1248-23 TL-ML 13TR	NN	IT
5	FG 12456TR40***** 1445V	22TM TT	IT
6	DF 125/22MT23.5-22TM ML-120	SL200	GER
7	MLC 111MR12L 12TM	TD SV123	IT
8	NN 123/34T22.5-12MR	SS1/1 NN	GER
9	CC 2500M14 11TM TN	T123	GER
10	CC 2500M14 11TM	NN1 TT	GER
SHEET2

I hope some body help

 

[Alaa mg]

is there any way to acheive it experts?