Complex Scheduling in Excel

Hi,

I am hoping someone could help me with the desired outputs here. I am managing training schedules for our program which offer multiple topics for different roles in different locations. I have a file attached here as an example with 2 sheets
Info - has all the data needed for the desired output
Schedule - has the desired output (which is currently being filled out manuall) for the Trainee scheduling and the bottom most table for Presenter scheduling.

My goal is to have a table that's automatically copying from the data entry of trainees and role per location so that it's easy to know which training topics to offer for the month based which roles are joining in the respective locations, as well as table that determines which presenters to invite based on their topic of expertise.

These are not a fixed format, in fact this is me thinking "manual". If there's a better way to visualize and format these tables so that it's easier to schedule them, I'm very much open to suggestions. Thank you!

Evee