Overview Sheet to show task for TODAY so I don't need to click through all other sheets

[cyx]

Hi all,
Context
I'm currently using excel to record and track my daily tasklist. I break it up according to pillars I'm in charge with, as the pillars grow, it became painful to go sheet-to-sheet to see my tasks for today.

Question
Can I have an Overview sheet for which, whenever I open the excel file, it will only show tasks that is due for that day? Can there be a VBA or vlookup function that can be hacked to read data from all the other sheets or something simpler?

Greatly appreciate your advice here! Thanks!
Attached is a sample of my task-tracking excel file.excel-question.xlsx

[xkittenxx]

Maybe you would like to review the Microsoft To-Do List Template:
http://office.microsoft.com/en-001/t...102425922.aspx

It may meet the needs you have or you might be able to pick it apart for inspiration.