I currently have a complex excel spreadsheet which calculates a large number of different things based on the client data inputted. The results are outputted into specific tables, templated text etc.

I also have a Word template, where the tables/text from the spreadsheet above are meant to appear in pre-determined sections (note page number will not always be the same, but the position in the document will always be the same in terms of chronological order).

I'd like to automate this process, so the excel spreadsheet and the templated word file 'talk' to each other. This would involve the excel tables/text automatically importing into the specified areas in the word template. An example of this would be a 'goals and objectives' table in the excel spreadsheet automatically importing into the 'Your goals & objectives' heading of the word template.

After some googling - it seems the answer lies in VB programming/macro's.
Is anyone able to help me out with that please?