Hi, I need help. I'm creating a calendar, based on events at our farm, which are on different dates.

Each event has its own column, the name of the event is at the top of the column, and the different dates it will occur are listed underneath it. I need to get this event name to automatically appear on an interactive calendar I made in the next sheet. (The calendar shows the date and weekday of a certain month in a certain year, you can change the month and year to whenever you want), I've tried the xlookup functions but I can't seem to get it working.

Please help if you can! I'd be happy to take advice.