Pls suggest for 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 Subscription dates on one sheet (say, on 1st sheet) automatically one the date of Subscription Ending, if file is opened on that date.

Also when I click that date on that sheet (say, 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

The report file uploaded is just an idea.
I want all Subscription date to be copied automatically from all sheets to one sheet (says, 1st sheet) one the date of Subscription Ending, if file is opened on that date.

Pls suggest how to do it.

Thanks & Regards