change the 8 to a 9:
Code:
=HYPERLINK("#"&LEFT(A2,2)&"!"&ADDRESS(MATCH("Total",INDIRECT(CONCATENATE("'",LEFT(A2,2),"'","!H:$H")),0),9),CONCATENATE("Pmts day ",LEFT(A2,2)))
Highlighting doesn't show in the above so:
=HYPERLINK("#"&LEFT(A2,2)&"!"&ADDRESS(MATCH("Total",INDIRECT(CONCATENATE("'",LEFT(A2,2),"'","!H:$H")),0),
9),CONCATENATE("Pmts day ",LEFT(A2,2)))