delete unmatched item for two sheets with another two sheets and put the similar to adjacent

[abdo meghari]

hello

I have sheets (TIRES,TIRES1,FS,BS) should match sheet TIRES for column B with sheet FS if the items are existed in sheet TIRES but not existed in sheet FS then should delete them from sheet TIRES and put the similar items into adjacent cells for sheet TIRES based on sheet FS . the same thing for sheet TIRES1, BS

list1.xlsx
	A	B
1	ITEM	BRAND
2	1	BS 175/70R13 B25 INDO
3	2	BS 175/70R13 EP150 THI
4	3	BS 195/60R15 AR20 INDO
5	4	BS 195/60R15 EP150 THI
6	5	BS 195/60R15 T001 JAP
7	6	BS 195/60R15 150EZ THI
8	7	BS 195/65R15 MY02 THI
9	8	BS 205/70R15 694 JAP
10	9	BS 185/70R13 EP150 INDO
11	10	BS 175/65R14 EP150 THI
12	11	BS 175/65R14 B25 INDO
13	12	BS 175/70R14 EP150 THI
14	13	BS 175/70R14 MY02 THI
15	14	BS 185/65R14 TEC THI
16	15	BS 185/65R14 150EZ INDO
17	16	BS 185/65R14 EP150 INDO
18	17	BS 195/70R14 150EZ INDO
19	18	BS 185/65R15 TC10 INDO
20	19	BS 185/65R15 T005 INDO
21	20	BS 185/65R15 T01 JAP
22	21	BS 185/65R15 B250 JAP
23	22	FS 205/55R16 RE003 THI
24	23	FS 205/65R15 EP150 INDO
25	24	FS 205/65R15 MY02 THI
26	25	FS 195/65R15 EP150 THI
27	26	FS 195/65R15 EP150 JAP
28	27	FS 195/65R15 T001 JAP
29	28	FS 195/55R16 EP300 THI
30	29	FS 205/65R15 TZ700 JAP
TIRES

list1.xlsx
	A	B
1	ITEM	BRAND
2	1	BS 175/70R13 B25 INDO
3	2	BS 175/70R13 EP150 THI
4	3	BS 195/60R15 AR20 INDO
5	4	BS 195/60R15 EP150 THI
6	5	BS 195/60R15 T001 JAP
7	6	BS 195/60R15 150EZ THI
8	7	BS 195/65R15 MY02 THI
9	8	BS 205/70R15 694 JAP
10	9	BS 185/70R13 EP150 INDO
11	10	BS 175/65R14 EP150 THI
12	11	BS 175/65R14 B25 INDO
13	12	BS 175/70R14 EP150 THI
14	13	BS 175/70R14 MY02 THI
15	14	BS 185/65R14 TEC THI
16	15	BS 185/65R14 150EZ INDO
17	16	BS 185/65R14 EP150 INDO
18	17	BS 195/70R14 150EZ INDO
19	18	BS 185/65R15 TC10 INDO
20	19	BS 185/65R15 T005 INDO
21	20	BS 185/65R15 T01 JAP
22	21	BS 185/65R15 B250 JAP
23	22	FS 205/55R16 RE003 THI
24	23	FS 205/65R15 EP150 INDO
25	24	FS 205/65R15 MY02 THI
26	25	FS 195/65R15 EP150 THI
27	26	FS 195/65R15 EP150 JAP
28	27	FS 195/65R15 T001 JAP
29	28	FS 195/55R16 EP300 THI
30	29	FS 205/65R15 TZ700 JAP
TIRES1

list1.xlsx
	A	B	C
1	ITEM	BRAND	QTY
2	1	FS 195/65R15 EP150 THI	27410
3	2	FS 195/65R15 EP150 JAP	28445
4	3	FS 195/65R15 T001 JAP	29480
5	4	FS 205/65R15 EP150 INDO	25340
6	5	FS 205/65R15 MY02 THI	26375
7	6	FS 205/65R15 TZ700 JAP	31550
8	7	FS 195/55R16 EP300 THI	30515
9	8	FS 205/55R16 RE003 THI	24305
FS

list1.xlsx
	A	B	C
1	ITEM	BRAND	QTY
2	1	BS 185/65R15 B250 JAP	18095
3	2	BS 195/60R15 AR20 INDO	2300
4	3	BS 195/60R15 EP150 THI	500
5	4	BS 195/60R15 T001 JAP	1535
6	5	BS 195/60R15 150EZ THI	2570
7	6	BS 195/65R15 MY02 THI	3605
8	7	BS 205/70R15 694 JAP	4640
9	8	BS 185/65R14 TEC THI	10850
10	9	BS 185/65R14 150EZ INDO	11885
11	10	BS 185/65R14 EP150 INDO	12920
BS

result

list1.xlsx
	A	B
1	ITEM	BRAND
2	1	FS 195/65R15 EP150 THI
3	2	FS 195/65R15 EP150 JAP
4	3	FS 195/65R15 T001 JAP
5	4	FS 205/65R15 EP150 INDO
6	5	FS 205/65R15 MY02 THI
7	6	FS 205/65R15 TZ700 JAP
8	7	FS 195/55R16 EP300 THI
9	8	FS 205/55R16 RE003 THI
TIRES

list1.xlsx
	A	B
1	ITEM	BRAND
2	1	BS 185/65R15 B250 JAP
3	2	BS 195/60R15 AR20 INDO
4	3	BS 195/60R15 EP150 THI
5	4	BS 195/60R15 T001 JAP
6	5	BS 195/60R15 150EZ THI
7	6	BS 195/65R15 MY02 THI
8	7	BS 205/70R15 694 JAP
9	8	BS 185/65R14 TEC THI
10	9	BS 185/65R14 150EZ INDO
11	10	BS 185/65R14 EP150 INDO
TIRES1

 

[abdo meghari]