collate results from a different excel file

I have a master excel file that we use daily, I would like to be able to get some information from that file into another.

I have attached 2 files, one is the master file, the other is the results file that I would like to get the information on.


I have done something similar with all the information in one document but im now stuck on how to get it all from another document. I have written text boxes in the results fie to explain what I would like the results to be and included an example for one of them.

I hope this can be done I cant figure it out so thought it would be a great challenge for somebody.

Thank you in advance