clear items for specific column based on header

[Alaa mg]

hello
I have three sheets contain duplicate items in column header CD should be delete them .

cas.xlsm
	B	C	D	E
1	CD	ITEM	BAT	QTY
2	CVF-12	FRIDG-1	BASD-1	12
3	CVF-12	FRIDG-2	BASD-2	3
4	CVF-12	FRIDG-3	BASD-3	4
5	CVF-13	FRIDG-4	BASD-4	5
6
7	CVF-14	OVEN-1	BASD-5	12
8	CVF-14	OVEN-2	BASD-6	3
9	CVF-15	OVEN-3	BASD-7	45
10
11	CVF-16	OVEN-4	BASD-8	12
12	CVF-18		BASD-10	12
13	CVF-19		BASD-11	3
14
mns

cas.xlsm
	C	D	E
1	CD	ITEM	QTY
2	CVF-12	FRIDG-1	12
3	CVF-12	FRIDG-2	3
4	CVF-12	FRIDG-3	4
5	CVF-13	FRIDG-4	5
6	CVF-14	OVEN-1	12
7	CVF-14	OVEN-2	3
8	CVF-15	OVEN-3	45
9	CVF-16	OVEN-4	12
10	CVF-18	OVEN-5	12
11	CVF-19	OVEN-6	3
LTTY

cases.xlsm
	H	I	J
1	CD	ITEM	QTY
2	CVF-13	FRIDG-4	5
3	CVF-14	OVEN-1	12
4	CVF-14	OVEN-2	3
5	CVF-15	OVEN-3	45
6	CVF-13	OVEN-4	12
7	CVF-13	OVEN-5	12
8	CVF-13	OVEN-6	3
LLO

RESULT should be

cas.xlsm
	B	C	D	E
1	CD	ITEM	BAT	QTY
2	CVF-12	FRIDG-1	BASD-1	12
3		FRIDG-2	BASD-2	3
4		FRIDG-3	BASD-3	4
5	CVF-13	FRIDG-4	BASD-4	5
6
7	CVF-14	OVEN-1	BASD-5	12
8		OVEN-2	BASD-6	3
9	CVF-15	OVEN-3	BASD-7	45
10
11	CVF-16	OVEN-4	BASD-8	12
12	CVF-18		BASD-10	12
13	CVF-19		BASD-11	3
14
mns

cas.xlsm
	C	D	E
1	CD	ITEM	QTY
2	CVF-12	FRIDG-1	12
3		FRIDG-2	3
4		FRIDG-3	4
5	CVF-13	FRIDG-4	5
6	CVF-14	OVEN-1	12
7		OVEN-2	3
8	CVF-15	OVEN-3	45
9	CVF-16	OVEN-4	12
10	CVF-18	OVEN-5	12
11	CVF-19	OVEN-6	3
LTTY

cas.xlsm
	H	I	J
1	CD	ITEM	QTY
2	CVF-13	FRIDG-4	5
3	CVF-14	OVEN-1	12
4		OVEN-2	3
5	CVF-15	OVEN-3	45
6		OVEN-4	12
7		OVEN-5	12
8		OVEN-6	3
LLO

 

[Alaa mg]

you want to use is the active sheet

No ! just I guess the problem . I want the first code you provided me. even if I use the last code still continues the problem.

I no know what's the problem . I try creating new workbook but the problem still continues.
by the way last code contains typo before for each line contains "."