separate multiple separated ranges into multiple sheets

[Maklil]

Hi
I have many separated ranges for each customer in one sheet , what I want split for each customer into multiple sheets and rename for each sheet based on customer name based on cell contains name . and should delete the data for each sheet has already splited becuase I want to update data could be change in sheet SUMMARISE

Names_6.xlsm
	A	B	C	D	E	F	G
1
2			NAME	BALANCE	DEBIT	CREDIT	NET
3			Maklil2	1,000.00	190,100.00	4,050.00	187,050.00
4
5		DATE	DESCRIBE	INVOICE NO	DEBIT	CREDIT	BALANCE
6		1/9/2022	BALANCE	-	1,000.00		1,000.00
7		11/1/2012	CASH	A99	100.00	100.00	1,000.00
8		16/1/2012	BANK	A106	5,000.00	1,000.00	5,000.00
9		18/1/2012	BANK	A106		100.00	4,900.00
10		19/1/2012	BANK	A107		250.00	4,650.00
11		20/1/2012	BANK	A108	10,000.00	100.00	14,550.00
12		21/1/2012	DEBT	A109	20,000.00		34,550.00
13		22/1/2012	BANK	A110	1,000.00	100.00	35,450.00
14		23/1/2012	DEBT	A111	150,000.00		185,450.00
15		24/1/2012	CASH	A112	2,000.00	1,200.00	186,250.00
16		25/1/2012	CASH	A113	2,000.00	1,200.00	187,050.00
17				TOTAL	191,100.00	4,050.00	187,050.00
18
19
20			NAME	BALANCE	DEBIT	CREDIT	NET
21			Maklil3	0.00	3,969,156,000.00	3,171,944,400.00	797,211,600.00
22
23		DATE	DESCRIBE	INVOICE NO	DEBIT	CREDIT	BALANCE
24		1/8/2022	BALANCE	-	0.00		0.00
25		26/1/2012	CASH	A114	3,000.00	1,200.00	1,800.00
26		27/1/2012	CASH	A115	3,000.00	1,200.00	3,600.00
27		28/1/2012	CASH	A116	3,000.00	1,200.00	5,400.00
28		29/1/2012	CASH	A117	4,000.00	2,000.00	7,400.00
29		30/1/2012	CASH	A118	5,000.00	2,800.00	9,600.00
30		31/1/2012	CASH	A119	6,000.00	3,600.00	12,000.00
31		1/2/2012	CASH	A120	7,000.00	4,400.00	14,600.00
32		2/2/2012	CASH	A121	8,000.00	5,200.00	17,400.00
33		3/2/2012	CASH	A122	9,000.00	6,000.00	20,400.00
34		4/2/2012	CASH	A123	10,000.00	6,800.00	23,600.00
35		5/2/2012	CASH	A124	11,000.00	7,600.00	27,000.00
36		6/2/2012	CASH	A125	12,000.00	8,400.00	30,600.00
37		7/2/2012	CASH	A126	13,000.00	9,200.00	34,400.00
38		8/2/2012	CASH	A127	14,000.00	10,000.00	38,400.00
Summaries

Cell Formulas
Range	Formula
D3,D21	D3	=IFERROR(VLOOKUP(C3, Tabla2[[NAME]:[BALANCE]], 3, 0), 0)
E3	E3	=SUM(Tabla121[DEBIT]) - D3
F3	F3	=SUM(Tabla121[CREDIT])
G3,G21	G3	=D3+E3-F3
B6,B24	B6	=IFERROR(VLOOKUP(C3, Tabla2[[NAME]:[DATE]], 2, 0), "---")
E6,E24	E6	=D3
G24:G38,G6:G16	G6	= N(G5) + E6 - F6
E17	E17	=SUBTOTAL(109, [DEBIT])
F17	F17	= SUBTOTAL(109, [CREDIT])
G17	G17	= Tabla121[[#Totals],[DEBIT]] - Tabla121[[#Totals],[CREDIT]]
E21	E21	=SUM(Tabla122[DEBIT]) - D21
F21	F21	=SUM(Tabla122[CREDIT])

RESULT

Names_6.xlsm
	A	B	C	D	E	F
1		NAME	BALANCE	DEBIT	CREDIT	NET
2		Maklil2	1,000.00	190,100.00	4,050.00	187,050.00
3
4	DATE	DESCRIBE	INVOICE NO	DEBIT	CREDIT	BALANCE
5	1/9/2022	BALANCE	-	1,000.00		1,000.00
6	11/1/2012	CASH	A99	100.00	100.00	1,000.00
7	16/1/2012	BANK	A106	5,000.00	1,000.00	5,000.00
8	18/1/2012	BANK	A106		100.00	4,900.00
9	19/1/2012	BANK	A107		250.00	4,650.00
10	20/1/2012	BANK	A108	10,000.00	100.00	14,550.00
11	21/1/2012	DEBT	A109	20,000.00		34,550.00
12	22/1/2012	BANK	A110	1,000.00	100.00	35,450.00
13	23/1/2012	DEBT	A111	150,000.00		185,450.00
14	24/1/2012	CASH	A112	2,000.00	1,200.00	186,250.00
15	25/1/2012	CASH	A113	2,000.00	1,200.00	187,050.00
16			TOTAL	191,100.00	4,050.00	187,050.00
Maklil2

Cell Formulas
Range	Formula
C2	C2	=IFERROR(VLOOKUP(B2, Tabla2[[NAME]:[BALANCE]], 3, 0), 0)
D2	D2	=SUM(Tabla1214[DEBIT]) - C2
E2	E2	=SUM(Tabla1214[CREDIT])
F2	F2	=C2+D2-E2
A5	A5	=IFERROR(VLOOKUP(B2, Tabla2[[NAME]:[DATE]], 2, 0), "---")
D5	D5	=C2
F5:F15	F5	= N(F4) + D5 - E5
D16	D16	=SUBTOTAL(109, [DEBIT])
E16	E16	= SUBTOTAL(109, [CREDIT])
F16	F16	= Tabla1214[[#Totals],[DEBIT]] - Tabla1214[[#Totals],[CREDIT]]

Names_6.xlsm
	A	B	C	D	E	F
1		NAME	BALANCE	DEBIT	CREDIT	NET
2		Maklil3	0.00	3,969,156,000.00	3,171,944,400.00	797,211,600.00
3
4	DATE	DESCRIBE	INVOICE NO	DEBIT	CREDIT	BALANCE
5	1/8/2022	BALANCE	-	0.00		0.00
6	26/1/2012	CASH	A114	3,000.00	1,200.00	1,800.00
7	27/1/2012	CASH	A115	3,000.00	1,200.00	3,600.00
8	28/1/2012	CASH	A116	3,000.00	1,200.00	5,400.00
9	29/1/2012	CASH	A117	4,000.00	2,000.00	7,400.00
10	30/1/2012	CASH	A118	5,000.00	2,800.00	9,600.00
11	31/1/2012	CASH	A119	6,000.00	3,600.00	12,000.00
12	1/2/2012	CASH	A120	7,000.00	4,400.00	14,600.00
13	2/2/2012	CASH	A121	8,000.00	5,200.00	17,400.00
14	3/2/2012	CASH	A122	9,000.00	6,000.00	20,400.00
15	4/2/2012	CASH	A123	10,000.00	6,800.00	23,600.00
16	5/2/2012	CASH	A124	11,000.00	7,600.00	27,000.00
17	6/2/2012	CASH	A125	12,000.00	8,400.00	30,600.00
18	7/2/2012	CASH	A126	13,000.00	9,200.00	34,400.00
19	8/2/2012	CASH	A127	14,000.00	10,000.00	38,400.00
Maklil3

Cell Formulas
Range	Formula
C2	C2	=IFERROR(VLOOKUP(B2, Tabla2[[NAME]:[BALANCE]], 3, 0), 0)
D2	D2	=SUM(Tabla122[DEBIT]) - C2
E2	E2	=SUM(Tabla122[CREDIT])
F2	F2	=C2+D2-E2
A5	A5	=IFERROR(VLOOKUP(B2, Tabla2[[NAME]:[DATE]], 2, 0), "---")
D5	D5	=C2
F5:F19	F5	= N(F4) + D5 - E5

I have about 20 separated ranges for each name , could be 5000 rows