auto fill items across sheets with different structure

[Mussa]

hello

I need fill items into column A for sheets IMPORT,EXPORT,REPORT based on sheet MAIN for column A .the sheet import,export are diffeernt structure, so should match column C with column B,C,Dfor sheet MAIN . as to sheet report is the same structure with match sheet MAIN .

fill.xlsm
	A	B	C	D	E	F
1	DEL NO	BATCH NO	TTL	TT1	IMPORT	EXPORT
2	CCD-1	CC-1	SS-1	TRU	12	10
3	CCD-2	CC-1	SS-1	LTR	12	5
4	CCD-3	CC-2	SS-2	FG	5	5
5	TTM
6	CCS-2	CC-1	SS-11	TRR	10	5
7	CCS-3	CC-1	SS-11	LTR	20	10
8	TTM
9	CSD-1	CS-1	LL-1	RRL	15	5
10	CSD-2	CS-2	LL-2	TTY	10	10
11	TTM
12	CCL3	CS-4	LL-4	NNW	10	10
13	CCL4	CC-2	SS-2	LTR	21	5
14	TTM
15	CCM5	CC-3	SS-3	LTR	22	5
16	TTM
MAIN

fill.xlsm
	A	B	C	D
1	DEL NO	ITEM	BATCH NO	IMPORT
2		1	CC-1 SS-1 TRU	56
3		2	CC-1 SS-11 TRR	7
4		3	CC-3 SS-3 LTR	9
IMPORT

fill.xlsm
	A	B	C	D
1	DEL NO	ITEM	BATCH NO	EXPORT
2		1	CS-4 LL-4 NNW	23
3		2	CC-2 SS-2 LTR	90
EXPORT

fill.xlsm
	A	B	C	D	E	F	G
1	DEL NO	ITEM	BATCH NO	TTL	TT1	IMPORT	EXPORT
2		1	CC-1	SS-1	TRU	89	67
3		2	CC-1	SS-1	LTR	2349
4		3	CS-4	LL-4	NNW	56	6
5		4	CC-2	SS-2	LTR		9
REPORT

if it's not clear just tell me to issue the result
thanks

 

[Mussa]

result should be

fill.xlsm
	A	B	C	D
1	DEL NO	ITEM	BATCH NO	IMPORT
2	CCD-1	1	CC-1 SS-1 TRU	56
3	CCS-2	2	CC-1 SS-11 TRR	7
4	CCM5	3	CC-3 SS-3 LTR	9
IMPORT

fill.xlsm
	A	B	C	D
1	DEL NO	ITEM	BATCH NO	EXPORT
2	CCL3	1	CS-4 LL-4 NNW	23
3	CCL4	2	CC-2 SS-2 LTR	90
EXPORT

fill.xlsm
	A	B	C	D	E	F	G
1	DEL NO	ITEM	BATCH NO	TTL	TT1	IMPORT	EXPORT
2	CCD-1	1	CC-1	SS-1	TRU	89	67
3	CCD-2	2	CC-1	SS-1	LTR	2349
4	CCL3	3	CS-4	LL-4	NNW	56	6
5	CCL4	4	CC-2	SS-2	LTR		9
REPORT

 

[Mussa]