VBA Macro to fill cells with data from other sheets

[Hungry Horace]

I am new to Excel and learning as I go and hoping someone here can help me with what I believe is a VBA issue.

I am working on a workbook that's purpose is to create a final report for Participants in a course.
Basically on one sheet would be a list of participants, another sheet would be the attendance record for the participants, on another would be the results of the tests/exams the participants took, and so on.
I have a template that takes the data of each individual from the different sheets and creates a final 'Certificate' for each participant that shows their attendance, exam scores, course pass/fail etc.
Whilst I can link the sheets for certain parts of the data for the Certificate I am having trouble making all of it work.
Is someone able to help with this issue? I am happy to post / send the workbook and provide a detailed explanation of exactly what data should appear in each cell of the Certificate sheet.

Thank you in advance for the help .

 

[Hungry Horace]

Thanks for the reply. Sorry I didn't post sooner but have been quite busy with the holiday season.
I'm afraid I still can't get it to work, I have attached a short video showing what I am doing in case I am missing something obvious.
Thanks again for the help.

https://www.dropbox.com/s/7k6ngdn72m5ewgq/Excel.mkv?dl=0

 

[mumps]

I can see from your video that the charts do not populate properly. Here is the link to the file I am using: https://app.box.com/s/on8paune52ivwctusd6s759ecdwchuua
When I run the macro in this file, all the charts populate properly. Is your actual file the same as this one or is it different in any way?

 

[Hungry Horace]

I am back into work today and I tried it on my work computer and everything is working fine. It must be incompatible with the version of excel I was using at home.
Thank you for all your help with this, I really appreciate it..

 

[mumps]

Glad it worked out.