How do I create a quarterly calendar that populates data from a table for each team?

mtt0306 

See the attached workbook for a partial solution. See the notes and references to documentation on the _Info worksheet.

This solution requires Excel 365 or Excel for the web.

For reference, here is the primary formula:

=LET( rows_thru_marker, MATCH("End of Cities/Dir.", $A:$A, 0),
  main_range, OFFSET(B9, 0, 0, rows_thru_marker - 9, 111),
  MAP( main_range, LAMBDA(cell, LET(
    city, OFFSET(cell, 0, 1 - COLUMN(cell)),
    date, OFFSET(cell, 5 - ROW(cell), 0),
    events_on_date, FILTER( 'Export Data'!$E$2:$E$26, ('Export Data'!$C$2:$C$26 =city)
        * ('Export Data'!$G$2:$G$26 <= date) * ('Export Data'!$H$2:$H$26 >= date), ""),
    display_events, XLOOKUP(events_on_date, tblEvents[Event], tblEvents[Display], "", 0),
    TEXTJOIN( "; ", TRUE, display_events )
  ) ) )
)