Need help on MS EXCEL

Hi there,

I am developing an EXCEL sheet for my grandson's training schedule and the compettition events to attend.

In the attached file, the first Tab is to record all the events throughout the year 2025 and insert "Y" on the event date to indicate Yes to Attend. On the second Tab "Events Summary", I would like to select the dates for each Federation where the Column contains "Y" in the first Tab, i.e. for each Federation, I want to only insert the dates which my grandson will attend.

Thank you.

Saad