Auto Populate Training Schedule in Calendar

Hello Excelfans

I do not know if it even can be done, but I got this assignment and I am totally stucked.
I worked my way already as far as I could, but now I need help.

I need to populate a "weekly trainng schedule" from a list of tasks (with the topic, trainer and venue) and a "monthly schedule" (with the task and time).
The monthly schedule must be arranged accoridng to the date and the weekly according to the time.
Additionally, the date in the weekly schedule needs to change according to the week, as I did already for the month.

Thank you so much for your help ... I don't know what else to do :-(

Alex

I would have though pivot tables could achieve what you want.