Hyperlink move down when insert new rows down a for each entry

[sapxl]

Hello Friends,
I'm trying to make hyperlink which need to keep moving down whenever I keep adding rows one by one down, so whenever I want to go to the bottom page just click on ""goto buttom page"" button... it would go to the bottom page in the sheet..

The Hyperlink to be slide down for each row insertion in a sheet, when we want to go to the bottom of the page on the click from top of the sheet. Appreciate your help in this matter..

I'm trying this formula but no luck: HYPERLINK(CONCATENATE(""#"",D3,""!B"",COUNTA(INDIRECT(D3&""B:B""))+1),""BOTTOMPAGE"").

COUNTING ONLY TODAYS NUMBER OF SALES and THIS MONTH NUMBER OF SALES.xlsx
	A	B	C	D
2				0
3			goto bottom page	0
4
5
6	22-Jun-20 7:22 PM	SDSDDSD
7	28-Jun-20 7:13 AM	DSDD	Hello Friends, I'm trying to make hyperlink which need to keep moving down whenever I keep adding rows one by one down, so whenever I want to go to the bottom page just click on "goto buttom page" button... it should be at the bottom page in the sheet.. I'm trying this formula but no luck: HYPERLINK(CONCATENATE("#",D3,"!B",COUNTA(INDIRECT(D3&"B:B"))+1),"BOTTOMPAGE")
8	29-Jun-20 7:13 AM	SDSDDSD
9	30-Jun-20 7:13 AM	KLKLKJJK
10	10-Jul-20 7:22 PM	JJJJ
11	11-Jul-20 7:22 PM	JJK
12	12-Jul-20 7:22 PM	DDDDD
13	13-Jul-20 7:22 PM	JJHHHH
14	14-Jul-20 7:22 PM	CCCC
15	15-Jul-20 7:22 PM	GGG
16	11-Jul-20 7:22 PM	GBBB
17	11-Jul-20 7:22 PM	SDDDDD
18	12-Jul-20 7:22 PM	dfsdddd
19	13-Jul-20 7:22 PM	sddsd
20	14-Jul-20 7:22 PM	sdddsd
21	15-Jul-20 7:22 PM	sdddsd
22	16-Jul-20 7:22 PM	sdddsd
23	17-Jul-20 7:22 PM	dffdf
24
25
26
27		BOTTOM PAGE
28
29
Sheet3

Cell Formulas
Range	Formula
D2	D2	=HYPERLINK(CONCATENATE("#",D2,"B",COUNTA(INDIRECT(D2&"B:B"))+1),"BOTTOMPAGE")
D3	D3	=HYPERLINK(CONCATENATE("#",D3,"!B",COUNTA(INDIRECT(D3&"B:B"))+1),"BOTTOMPAGE")