It is an Excel spreadsheet with two workbooks, Schedule and Agenda.
On the Schedule you will see the Sundays with details of who is conducting, the hymn numbers, prayers, speakers.
On the Agenda you will see the program for the upcoming Sunday.
There is also a hidden workbook with details of all the hymn numbers and titles, hence how you only input the hymn number on the schedule but it prints the hymn title on the agenda as well

It is simple and it works. There are no frilly extras.
If anyone fancy "beautifying" it feel free and repost your changed version.
Example is attached