Thank you for response. Let's see if I can better explain what the problem is:
In numbers I have a workbook with different tabs one of the tabs has different column header names some of the column heading as dates, Hymn Numbers and different actions or tasks that need to be addressed at different points of a meeting. Then in pages, I have an agenda template that based on the date that is entered on the page would then auto fill the pages template with the data from the numbers template.
With the GOAL of automation for an agenda template that in the past has taken some time to prepare for every weekly meeting.
Funny part is that I know how to make it work in Microsoft Office for PC, but not when it comes to MAC applications, but having said that over the past few years since switching over to MAC I'm getting better.
Hope this helps, let me know if you need more details.
Thanks