getting values from sheet to next based on empty cells

[abdo meghari]

hello
I have sheet from JAN to DEC should match column B with sheet MAIN , then should fill values in column C,D ,if there are many new items in sheet MAIN but are not existed in others sheets , then should add to others sheets and arrange and sorting based on sheet MAIN .
but when pull values for next sheet , don't pull to next sheet if sheet precede of it still columns C,D are empty . for instance if sheet JAN colums C,D are empty don't move to next sheet FEB before filling sheet JAN and if sheet JAN column C,D are filled then next time ignore sheet JAN and move next sheet FEB to filling and so on for each next sheet should be filled.

fill next sheet.xlsm
	A	B	C	D
1	ITEM	BRAND	ARRIVES	RETURNS
2	1	BS 1200R20 G580 THI	113
3	2	BS 1200R20 G580 JAP	1269	1
4	3	BS 1200R24 G582 JAP	191
5	4	BS 1200R20 R187 JAP	476	11
6	5	BS 1200R24 G582 JAP	503	11
7	6	BS 13R22.5 R187 JAP	81	81
8	7	BS 1400R20 R180 JAP	132	11
9	8	BS 1400R20 R180BZ JAP	43	11
10	9	BS 155R12C R623 INDO	30	123
11	10	BS 165R13C R624 INDO	12	124
12	11	BS 175/65R14 EP150 JAP	50	44
13	12	BS 175/70R13 EP150 THI	52	55
14	13	BS 175/70R14 EP150 THI	31	66
15	14	BS 175/70R14 MY02 THI	1	77
16	15	BS 185/65R14 EP150 INDO	26	88
17	16	BS 185/65R14 TEC THI	5	99
18	17	BS 185/65R15 T005 INDO	2	12
19	18	BS 185/65R15 B250 JAP	183
20	19	BS 185/65R15 T001 JAP	200
21	20	BS 185/70R13 EP150 INDO	45
22	21	BS 185/70R14 B250 THI	71
23	22	BS 185R14C 613V JAP	31
24	23	BS 195/55R16 EP300 THI	137
25	24	BS 195/60R15 EP150 THI	40
26	25	BS 195/60R15 T001 JAP	206
27	26	BS 195/65R15 EP150 JAP	89
28	27	BS 195/65R15 EP150 THI	50
29	28	BS 195/65R15 T001 JAP	321
30	29	BS 195/70R15C R623 JAP	40
31	30	BS 195/75R16C R613 JAP	152
32	31	BS 195R14C 613V JAP	128
33	32	BS 195R14C R623 THI	40
34	33	BS 195R15C R660 TR	4
MAIN

fill next sheet.xlsm
	A	B	C	D
1	ITEM	BRAND	ARRIVES	RETURNS
2	1	BS 185R14C 613V JAP
3	2	BS 195/55R16 EP300 THI
4	3	BS 195/60R15 EP150 THI
5	4	BS 195/60R15 T001 JAP
6	5	BS 1200R24 G582 JAP
7	6	BS 13R22.5 R187 JAP
8	7	BS 1400R20 R180 JAP
9	8	BS 1400R20 R180BZ JAP
10	9	BS 155R12C R623 INDO
11	10	BS 165R13C R624 INDO
12	11	BS 175/65R14 EP150 JAP
13	12	BS 1200R20 G580 THI
14	13	BS 1200R20 G580 JAP
15	14	BS 1200R24 G582 JAP
16	15	BS 1200R20 R187 JAP
17	16	BS 175/70R13 EP150 THI
18	17	BS 175/70R14 EP150 THI
19	18	BS 175/70R14 MY02 THI
20	19	BS 185/65R14 EP150 INDO
21	20	BS 185/65R14 TEC THI
22	21	BS 185/65R15 T005 INDO
23	22	BS 185/65R15 B250 JAP
24	23	BS 185/65R15 T001 JAP
25	24	BS 185/70R13 EP150 INDO
26	25	BS 185/70R14 B250 THI
JAN

fill next sheet.xlsm
	A	B	C	D
1	ITEM	BRAND	ARRIVES	RETURNS
2	1	BS 1200R20 G580 THI
3	2	BS 1200R20 G580 JAP
4	3	BS 1200R24 G582 JAP
5	4	BS 1200R20 R187 JAP
FEB

fill next sheet.xlsm
	A	B	C	D
1	ITEM	BRAND	ARRIVES	RETURNS
2	1	BS 185/65R14 EP150 INDO
3	2	BS 185/65R14 TEC THI
4	3	BS 185/65R15 T005 INDO
5	4	BS 185/65R15 B250 JAP
6	5	BS 185/65R15 T001 JAP
7	6	BS 185/70R13 EP150 INDO
8	7	BS 185/70R14 B250 THI
9	8	BS 185R14C 613V JAP
10	9	BS 195/55R16 EP300 THI
11	10	BS 195/60R15 EP150 THI
12	11	BS 195/60R15 T001 JAP
13	12	BS 195/65R15 EP150 JAP
14	13	BS 195/65R15 EP150 THI
15	14	BS 195/65R15 T001 JAP
16	15	BS 195/70R15C R623 JAP
17	16	BS 195/75R16C R613 JAP
18	17	BS 195R14C 613V JAP
19	18	BS 195R14C R623 THI
20	19	BS 195R15C R660 TR
21	20	BS 195R15C 613V JAP
22	21	BS 195R15C R623 THI
23	22	BS 205/55R16 ER30 JAP
24	23	BS 205/55R16 T005 POL
25	24	BS 205/55R16 T005 THI
26	25	BS 205/60R16 T001 JAP
27	26	BS 205/60R16 T005 THI
28	27	BS 205/65R16 EP300 INDO
29	28	BS 205/65R15 EP150 INDO
30	29	BS 205/65R15 T005 THI
31	30	BS 205/70R15C R623 THI
32	31	BS 205/70R15C R660 TR
33	32	BS 205R16C D840 THI
34	33	BS 215/45R17 EA03 THI
35	34	BS 215/50R17 EP300 THI
36	35	BS 215/55R16 EP300 INDO
37	36	BS 215/55R17 AR20 INDO
38	37	BS 215/55R17 GR90 INDO
39	38	BS 215/55R17 T005 JAP
40	39	BS 215/60R16 EP300 THI
41	40	BS 215/60R16 ER30 JAP
42	41	BS 215/60R16 T005 THI
43	42	BS 215/65R15 T005 INDO
44	43	BS 215/65R16 D688 JAP
45	44	BS 215/70R15C R623 THI
46	45	BS 215/70R15C R660 TR
47	46	BS 215/70R16 D697 INDO
48	47	BS 225/40R18 050A JAP
49	48	BS 225/45R17 RE050A JAP
50	49	BS 225/45R18 T005 JAP
51	50	BS 225/50R17 EP300 THI
52	51	BS 225/55R16 EP300 INDO
53	52	BS 225/55R16 T001 JAP
54	53	BS 225/55R17 EP300 THI
55	54	BS 225/55R17 T005 JAP
56	55	BS 225/55R18 AL01 JAP
57	56	BS 225/60R16 EP300 INDO
58	57	BS 225/60R17 D-SPORT JAP
59	58	BS 225/60R18 AL01 JAP
60	59	BS 225/70R15C R623 JAP
61	60	BS 225/70R16 D687 JAP
62	61	BS 225/70R16 H005 THI
63	62	BS 225/70R17 D697 THI
64	63	BS 225/70R17 D697 JAP
65	64	BS 225/95R16C D619 JAP
66	65	BS 235/35ZR19 RE050A JAP
67	66	BS 235/40R18 T001 JAP
68	67	BS 235/45R17 EA03 THI
69	68	BS 235/45R18 PSPORT THI
70	69	BS 235/50R18 AL01 JAP
71	70	BS 235/55 R17 T005 THI
72	71	BS 235/55 R19 AL01 JAP
73	72	BS 235/55R17 ER30 JAP
74	73	BS 235/55R18 E031 JAP
75	74	BS 235/55R18 D687 JAP
76	75	BS 235/60R16 AL01 JAP
77	76	BS 235/60R16 T01 JAP
78	77	BS 235/60R17 AL01 JAP
79	78	BS 235/60R18 D400 JAP
80	79	BS 235/65R17 D697 INDO
81	80	BS 235/85R16 D697 INDO
82	81	BS 245/40R17 T001 JAP
83	82	BS 245/40R18 T005 JAP
84	83	BS 245/40R18PR RE050A JAP
85	84	BS 245/40R19 T005 JAP
86	85	BS 245/40ZR20 PSPORT JAP
87	86	BS 245/40ZR20 S001 JAP
88	87	BS 245/45R17 T05A JAP
89	88	BS 245/45R18 EP300 THI
90	89	BS 245/45R19 T005A JAP
91	90	BS 245/50R19 T005 JAP
92	91	BS 245/55R19 AL01 JAP
93	92	BS 245/65R17 D689 JAP
94	93	BS 245/70R16 D684 THI
95	94	BS 245/70R16 D697 JAP
96	95	BS 245/70R17 684A JAP
97	96	BS 245/75R17 693A JAP
98	97	BS 255/35R19 S001 JAP
99	98	BS 255/45R20 D-SPORT JAP
100	99	BS 255/50R20 AL01 JAP
101	100	BS 255/70 R16 D697 THI
102	101	BS 255/70R15C D840 THI
103	102	BS 255/70R16 H005 THI
104	103	BS 265/50R20 DHPA JAP
105	104	BS 265/55R20 D693 JAP
106	105	BS 265/60R18 D840 JAP
107	106	BS 265/60R18 AL01 JAP
108	107	BS 265/65R17 H005 JAP
109	108	BS 265/65R18 D693 JAP
110	109	BS 265/70R15 D697 INDO
111	110	BS 265/70R16 D697 THI
112	111	BS 265/70R16 D840 THI
113	112	BS 265/70R18 D684 JAP
114	113	BS 275/35R21 RE21 JAP
115	114	BS 275/40R18 S007 JAP
116	115	BS 275/40R20 D-SPORT JAP
117	116	BS 275/40ZR19 PSPORT JAP
118	117	BS 275/45R19 AL01 JAP
119	118	BS 275/45R20 D-SPORT JAP
120	119	BS 275/55R17 D-SPORT JAP
121	120	BS 275/55R20 AL01 INDO
122	121	BS 275/65R18 AL01 JAP
123	122	BS 275/70 R16 D697 THI
124	123	BS 275/70R16 H005 THI
125	124	BS 275/70R16 D694 JAP
126	125	BS 285/50R20 D-SPORT JAP
127	126	BS 285/60R18 DHPS JAP
128	127	BS 285/65R17 R683 JAP
129	128	BS 295/35R20 S001 JAP
130	129	BS 315/80R22.5 R152 JAP
131	130	BS 315/80R22.5 R184 JAP
132	131	BS 315/80R22.5 R184 THI
133	132	BS 315/80R22.5 G580 JAP
134	133	BS 315/80R22.5 G582 THI
135	134	BS 325/95R24 M840 JAP
136	135	BS 385/65R22.5 R164 JAP
137	136	BS 385/65R22.5 R164 THI
138	137	BS 425/65R22.5 R164 JAP
139	138	BS 445/65R22.5 R164 JAP
140	139	BS 650R16 R230 JAP
141	140	BS 700R16 R230 JAP
142	141	BS 750R16 R230 JAP
143	142	BS 750R16 VSJ JAP
144	143	BS 8.25R16 R180 JAP
145	144	BS LT285/75R16 AT001 JAP
146	145	DT 1200R24 DA53 THI
147	146	DT 385/65R22.5 DT40 THI
148	147	FS 215/60R16 XL IT
MAR

for instance result in sheet JAN

fill next sheet.xlsm
	A	B	C	D
1	ITEM	BRAND	ARRIVES	RETURNS
2	1	BS 1200R20 G580 THI	113
3	2	BS 1200R20 G580 JAP	1269	1
4	3	BS 1200R24 G582 JAP	191
5	4	BS 1200R20 R187 JAP	476	11
6	5	BS 1200R24 G582 JAP	503	11
7	6	BS 13R22.5 R187 JAP	81	81
8	7	BS 1400R20 R180 JAP	132	11
9	8	BS 1400R20 R180BZ JAP	43	11
10	9	BS 155R12C R623 INDO	30	123
11	10	BS 165R13C R624 INDO	12	124
12	11	BS 175/65R14 EP150 JAP	50	44
13	12	BS 175/70R13 EP150 THI	52	55
14	13	BS 175/70R14 EP150 THI	31	66
15	14	BS 175/70R14 MY02 THI	1	77
16	15	BS 185/65R14 EP150 INDO	26	88
17	16	BS 185/65R14 TEC THI	5	99
18	17	BS 185/65R15 T005 INDO	2	12
19	18	BS 185/65R15 B250 JAP	183
20	19	BS 185/65R15 T001 JAP	200
21	20	BS 185/70R13 EP150 INDO	45
22	21	BS 185/70R14 B250 THI	71
23	22	BS 185R14C 613V JAP	31
24	23	BS 195/55R16 EP300 THI	137
25	24	BS 195/60R15 EP150 THI	40
26	25	BS 195/60R15 T001 JAP	206
27	26	BS 195/65R15 EP150 JAP	89
28	27	BS 195/65R15 EP150 THI	50
29	28	BS 195/65R15 T001 JAP	321
30	29	BS 195/70R15C R623 JAP	40
31	30	BS 195/75R16C R613 JAP	152
32	31	BS 195R14C 613V JAP	128
33	32	BS 195R14C R623 THI	40
34	33	BS 195R15C R660 TR	4
JAN

the data could be 7000 rows.