Is there a function to find a data matching the current date?

[eeevener903]

I have a spreadsheet this lists data regarding projects. I have one worksheet for each location I work with. Each project (in a row) has a due date assigned to it.
What I want to do is have any project that is due during the current week to filter into the first page of the spreadsheet. This way I know what is due this week without searching every page and I can refresh the spreadsheet each week to show me what is up for the current week.
Is this possible? Any help would be great, thanks!!!

[shg]

Welcome to the forum, eeevener.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.