Dynamic hyper link based on cell input

Hi,
I have developed a data driven report book for tracking safety and man hours ect. On one tab, I have developed a daily diary that is 6 pages across (mon to sat) and x pages down to account for the month. Each page has a date that changes based on information on a different tab resulting in all the pages reflecting each working day in the month.

I am stuck, trying to make a dynamic hyperlink at the top based on a date entered in A1 (that is a drop down cell). The corresponding date will be somewhere within an array (A5:A0300) but the formula wont work. I can make it work for one column but not an array. I have tried these two variations. Not a real genius at this, any help is appreciated

=HYPERLINK("#INDEX(A:AO,MATCH("&A1&",A:AO,1))","Link")
=HYPERLINK("#Index!(A5:AO300 & MATCH($A$1,A5:A0300,0),0)"","GoToRecord")

Thanks CP, but not quite, it is linking to cells past the last column referenced being AO, effectively in nowhere. I tried playing with it but no luck. Its almost there. Any thoughts CP?