Linking Calendar and Service Rota to publish next service information

Would it be possible to produce a shortcode or something that will collect data from the Calendar (services), the rota (who is preaching and leading) add a theme so that the short code would produce something like “Next Sunday (calendar date) our service will be led by <rota- leader> and <rota-preacher> will be preaching on <theme>”

At the moment i have a recurring calendar event for the Morning Service, but I cannot see a way of editing each week with preacher / leader information.

Just a thought! But it would save me time each week. 🙂