Getting to an item, buy click on a cell, using code

[hendrikbez]

I want to put on one of my worsheets (have many entries on it) to do the following.
on one worksheet, every _+ 9 rows I have a name, from B9: to B968 (there will be more added in future.
The names I get from "Chart of Accounts", and need to add them in "GL-MO 10"
There are two diffrent options (inkomste) and (uitgawes)

I am trying it with hyperlink, but the namesa can change or new ones added, is there a better way to do it with code.

I am also going to all of the gl-mo tabs

test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	COTN / KVDN Boksburg								Inkomse			Uitgawes
2	Algemene lêer								Naskoolsentrum** Nie na bank	Offers Sondag 01		Distrik Tiendes	Kompleks (Parkrand Village)
3	Oktober			2022					Tiendes Ds Pieter**	Offers Sondag 02		Salaris Ds Luke	Kinderfees
4									Tiendes Ds Luke	Offers Sondag 03		Salaris Ds Pieter**	Sondagskoolrekening:
5									Bezuidenhout	Offers Sondag 04		Lone (Tuinier)(Eric)	Tuinslang
6		Inkomste							Mienie Greisel	Offers Sondag 05		Lone (Skoonmaker)	Voorskot (Blaine)
7	Datem	Beskryeing	Ck#	Uitgawes	INKOMSTE	Balans			Kaye	Sondag Skool 01		Lone (Week 3)	Blok Drein
8						4 729,26			Thanks to the Lord	Sondag Skool 02		Lone (Week 4)	Seël vir die Doopbad
9	40001	Naskoolsentrum** Nie na bank							Anoniem	Sondag Skool 03		Lone (Week 5)	Discord data
10		Begin Balans				0,00			Ob pmt tiende	Sondag Skool 04		Kleinkas Rekonsiliasie	Belgeld vir polis
11	01 Oct 2022				-	-			English service	Sondag Skool 05		Elektrisiteit	Brandstof
12						-			Ekstra	Sending Paasoffer		Ekurhuleni (W&L) STADSRAAD)	Geld vir Oktober se ete
13						-			Free Plate	Sending Dankoffer		Kruideniersware	Vets
14						-			Tiendes 01	Sending Albaster		Skryfbehoeftes	Print/pna/crazy plastic
15						-			Tiendes 02	Jeug		Brandstof	Service Fees
16		Totaal		-	-				Tiendes 03	Manne		Kampe/ Konfer.	Monthly account fee
17									Tiendes 04	Dames		Santam Versekering	Cash Deposit Fee
18									Tiendes 05	Bejaardes		Kontantkrag Aankope	Ekstra 01
19	40100	Tiendes Ds Pieter**							Tiendes 06	Kinderfees		Bankkoste	Ekstra 02
20		Begin Balans				-			Tiendes 07	Fasiliteit Gebruik		Sending Paasoffer	Ekstra 03
21						-			Tiendes 08	Bou fonds		Sending Dankoffer	Ekstra 04
22						-			Tiendes 09	Skenkings		Sending Alabaster	Ekstra 05
23						-			Tiendes 10	Verf fonds		Gebou Onder- houd	Ekstra 06
24						-			Tiendes Direkte KT 01	Ekstra 01		Jeugaksie	Ekstra 07
25		Totaal		-	-				Tiendes Direkte KT 02	Ekstra 02		Manne	Ekstra 08
26									Tiendes Direkte KT 03	Ekstra 03		Dames	Ekstra 09
27									Tiendes Direkte KT 04	Ekstra 04		Bejaardes	Ekstra 10
28	40101	Tiendes Ds Luke							Tiendes Direkte KT 05	Ekstra 05		Alarm
29		Begin Balans				-
30						-
31						-
32						-
33						-
34		Totaal		-	-
GL-MO 10

Cell Formulas
Range	Formula
A1	A1	='Chart of Accounts'!A4:B4
I2:I28	I2	='Chart of Accounts'!B9
J2:J28	J2	='Chart of Accounts'!B36
A3	A3	='Chart of Accounts'!L2
D3	D3	='Chart of Accounts'!A6
F8	F8	='SOA MO 10'!G8
A9:B9	A9	='Chart of Accounts'!A9
F10	F10	='GL-MO 9'!F353
F11:F15,F30:F33,F21:F24	F11	=E11-D11+F10
D16:E16	D16	=SUM(D11:D15)
A19:B19	A19	='Chart of Accounts'!A10
F20,F29	F20	=F15
D25:E25,D34:E34	D25	=SUM(D21:D24)
M2:M27	M2	='Chart of Accounts'!B91
A28:B28	A28	='Chart of Accounts'!A11
L2:L28	L2	='Chart of Accounts'!B64