Copy specific columns after column contains BALANCES word in the header

[Hasson]

Hello
I would macro to deal with 2000 names in CLS sheet and 5000 rows for duplicates names in VB sheet.
in CLS sheet should show result in G:L after match NAME column between two sheets .
in VB sheet will contains duplicates names . so should merge amount for DEBIT,CREDIT columns when show in J,K columns in CLS sheet.
I don't want power query I don't used to use it , so I don't need it.

HS ‫‬.xlsx
	A	B	C
1	DATE	NAME	BALANCES
2	11/08/2024	AHHGGJ-1	5,100.00
3	12/09/2024	AHHGGJ-2	2,500.00
4	11/08/2024	AHHGGJ-3	28,200.00
5	11/09/2024	AHHGGJ-4	39,368.00
6	12/09/2024	AHHGGJ-5	2,370.00
7	TOTAL		77,538.00
CLS

Cell Formulas
Range	Formula
C7	C7	=SUM(C2:C6)

HS ‫‬.xlsx
	A	B	C	D	E	F
1	DATE	NAME	VMN	DEBIT	CREDIT	TOTAL
2	11/08/2024	AHHGGJ-1	REC	2,000.00		2,000.00
3	12/09/2024	AHHGGJ-2	PPA		1,200.00	-1,200.00
4	13/09/2024	AHHGGJ-2	REC	3,000.00		3,000.00
5	14/09/2024	AHHGGJ-1	REC	1,200.00		1,200.00
6	15/09/2024	AHHGGJ-2	PPA		100.00	-100.00
7	16/09/2024	AHHGGJ-3	REC	2,000.00		2,000.00
8	17/09/2024	AHHGGJ-4	REC	1,500.00		1,500.00
9	18/09/2024	AHHGGJ-5	REC	1,000.00		1,000.00
10	TOTAL			10,700.00	1,300.00	9,400.00
VB

Cell Formulas
Range	Formula
F2:F10	F2	=D2-E2
D10:E10	D10	=SUM(D2:D9)

I expect result like this

HS ‫‬.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	DATE	NAME	BALANCES				DATE	NAME	BALANCES	DEBIT	CREDIT	TOTAL
2	11/08/2024	AHHGGJ-1	5,100.00				11/08/2024	AHHGGJ-1	5,100.00	3,200.00		8,300.00
3	12/09/2024	AHHGGJ-2	2,500.00				12/09/2024	AHHGGJ-2	2,500.00	3,000.00	1,300.00	4,200.00
4	11/08/2024	AHHGGJ-3	28,200.00				11/08/2024	AHHGGJ-3	28,200.00	2,000.00		30,200.00
5	11/09/2024	AHHGGJ-4	39,368.00				11/09/2024	AHHGGJ-4	39,368.00	1,500.00		40,868.00
6	12/09/2024	AHHGGJ-5	2,370.00				12/09/2024	AHHGGJ-5	2,370.00	1,000.00		3,370.00
7	TOTAL		77,538.00				TOTAL		77,538.00	10,700.00	1,300.00	86,938.00
CLS

Cell Formulas
Range	Formula
L2:L6	L2	=I2+J2-K2
C7,I7:L7	C7	=SUM(C2:C6)

thanks in advanced