How to do in excel

Dear all,

Pls suggest for my following issue related to Microsoft Excel.

I created a Report in Excel having many sheets. In all sheets, Subscription Dates are available.
Now I want all those Subscription dates on my 1st sheet automatically one the Subscription Ending Date, if file is opened on that date. Also when I click that date on 1st sheet, the corresponding sheet should open with location of that cell (like hyperlink).

Download the report file here. http://speedy.sh/MjZwA/Sales-Report.xlsx

You see the same thing in this that I told. I want all Subscription date automatically from all sheets to 1st sheet at the Subscription Ending date, if file is opened on that date.

Pls suggest how to do it.

Thanks & Regards