How to select rows in Excel by current date?

Question

excel

There are two sheets.
There are columns with dates and you need to transfer lines with these dates from one sheet where there are dates today to the second sheet. dynamically

Answer 1

select the source data (you can spare it or just click on it) and insert menu - pivot table, then set the columns you need and filter by date

Answer 2

no it's not that.
There is a table 1 with dates in lines.
There is a table 2 in which the rows from table 1 should appear, provided that the Date in them = TODAY