Creating a summary sheet based on date and printing it

I've attached the file that I've been working on. It will be a large list of sporting events that will have a bet associated with it.

What I am trying to do is create a daily summary sheet. I'm envisioning it searching through all the worksheets and finding the last entry in row K. If the date equals todays date then it will fill in the data in the summary sheet and print it.

I have some macros that I've been trying but I can't seem to find something that meets all my criteria. I've been searching for a while and cant seem to find it. I'm hoping someone has something similar already done that I can modify and use.

Thanks in advance. Mike.

example_sheet.xlsx

Here is the attached solution.

Let me know if this is what you are looking for.

Thanks & Warm Regards,
Prasad Avasare

Prasad,

Thank you that is very close to what I am looking for. How would I extend the formula to cover ALL current sheets and ALL future sheets? I'm thinking this needs to be a macro. What do you think?