repeat missed items based on match helper column

[abdo meghari]

hello
I would match column B across multiple sheets with helper column K into sheet FS ,if the missed item in column B matched on of them into column K , then should repeat for all the items across multiple sheets . for instance the sheet FS one item contain INDO ,then should fill all of item INDO in last position ,also sheet DTYO there are about four items into column B contain THI , then should fill all of the items THI .as to sheet FSI there are about three items into column B contain JAP, then should fill all of the items JAP .
but I have rare case , somtimes there is no items into column B match with column K . I mean to don't contain any items based on column K then should fill all of the items JAP

I put expected result from column E: G but the result should be in column B across multiple sheets.

BB1.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	ITEM	BRAND	QTY		ITEM	BRAND	QTY				ORIGIN
2	1	BS 175/70R13 B25	220		1	BS 175/70R13 B25 INDO	220				JAP
3	2	BS 175/70R13 EP150	100		2	BS 175/70R13 EP150 INDO	100				INDO
4	3	BS 185/70R13 EP150	10		3	BS 185/70R13 EP150 INDO	10				THI
5	4	BS 175/65R14 EP150	90		4	BS 175/65R14 EP150 INDO	90				IND
6	5	BS 175/65R14 B25	12		5	BS 175/65R14 B25 INDO	12				CHI
7	6	BS 175/70R14 EP150	12		6	BS 175/70R14 EP150 INDO	12
8	7	BS 175/70R14 MY02	43		7	BS 175/70R14 MY02 INDO	43
9	8	BS 185/65R14 TEC	45		8	BS 185/65R14 TEC INDO	45
10	9	BS 185/65R14 150EZ INDO	67		9	BS 185/65R14 150EZ INDO	67
11	10	BS 185/65R14 EP150	12		10	BS 185/65R14 EP150 INDO	12
12	11	BS 195/70R14 150EZ	34		11	BS 195/70R14 150EZ INDO	34
13	12	BS 185/65R15 TC10	23		12	BS 185/65R15 TC10 INDO	23
14	13	BS 185/65R15 T005	12		13	BS 185/65R15 T005 INDO	12
15	14	BS 185/65R15 T01	34		14	BS 185/65R15 T01 INDO	34
16	15	BS 185/65R15 B250	56		15	BS 185/65R15 B250 INDO	56
17	16	BS 195/60R15 AR20	34		16	BS 195/60R15 AR20 INDO	34
18	17	BS 195/60R15 EP150	56		17	BS 195/60R15 EP150 INDO	56
19	18	BS 195/60R15 T001	78		18	BS 195/60R15 T001 INDO	78
20	19	BS 195/60R15 150EZ	12		19	BS 195/60R15 150EZ INDO	12
21	20	BS 195/65R15 MY02	34		20	BS 195/65R15 MY02 INDO	34
22	21	BS 195/65R15 EP150	56		21	BS 195/65R15 EP150 INDO	56
23	22	BS 195/65R15 EP150	78		22	BS 195/65R15 EP150 INDO	78
24
FS

BB1.xlsm
	A	B	C	D	E	F	G
1	ITEM	BRAND	QTY		ITEM	BRAND	QTY
2	1	DTYO 315/80R22.5 R184	200		1	DTYO 315/80R22.5 R184 THI	200
3	2	DTYO 315/80R22.5 R184 THI	100		2	DTYO 315/80R22.5 R184 THI	100
4	3	DTYO 315/80R22.5 R152	120		3	DTYO 315/80R22.5 R152 THI	120
5	4	DTYO 315/80R22.5 R152 THI	130		4	DTYO 315/80R22.5 R152 THI	130
6	5	DTYO 315/80R22.5 G580	100		5	DTYO 315/80R22.5 G580 THI	100
7	6	DTYO 315/80R22.5 G582 THI	150		6	DTYO 315/80R22.5 G582 THI	150
8	7	DTYO 315/80R22.5 DS50 THI	200		7	DTYO 315/80R22.5 DS50 THI	200
9	8	DTYO 175/70R13 B25	120		8	DTYO 175/70R13 B25 THI	120
10	9	DTYO 175/70R13 EP150	100		9	DTYO 175/70R13 EP150 THI	100
11	10	DTYO 185/70R13 EP150	120		10	DTYO 185/70R13 EP150 THI	120
12	11	DTYO 185/65R15 T01	100		11	DTYO 185/65R15 T01THI	100
DTYO

BB1.xlsm
	A	B	C	D	E	F	G
1	ITEM	BRAND	QTY		ITEM	BRAND	QTY
2	1	FSI 185/65R14 TEC	120		1	FSI 185/65R14 TEC JAP	120
3	2	FSI 185/65R14 150EZ JAP	100		2	FSI 185/65R14 150EZ JAP	100
4	3	FSI 185/65R14 EP150	200		3	FSI 185/65R14 EP150 JAP	200
5	4	FSI 195/70R14 150EZ	230		4	FSI 195/70R14 150EZ JAP	230
6	5	FSI 185/65R15 TC10	120		5	FSI 185/65R15 TC10 JAP	120
7	6	FSI 185/65R15 T005	150		6	FSI 185/65R15 T005 JAP	150
8	7	FSI 185/65R15 T01	100		7	FSI 185/65R15 T01 JAP	100
9	8	FSI 315/80R22.5 R152 JAP	120		8	FSI 315/80R22.5 R152 JAP	120
10	9	FSI 315/80R22.5 R152 JAP	130		9	FSI 315/80R22.5 R152 JAP	130
FSI

 

[abdo meghari]

cross posted
repeat missed items based on match helper column

 

[abdo meghari]

it's solved

 

[Peter_SSs]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.