Hello, I am new here

I have a question about what I am calling "intelligent links".

I have a large spreadsheet being used as a timesheet. It is possible to create a clickable link that takes the user to the "today" section of the file. The problem being that with the passing of each day, the section for today moves down about 20 rows!
Many thanks

T