VBA macro help (selecting data from mutliple worksheets in subfolders)

Hi all

I'm trying to produce a section of VBA code or macro that will enable me to take data from a single cell of multiple worksheets saved in different subfolders. Needless to say I'm having quite a bit of trouble getting it to work and at present I'm not sure if its even possible.

Attached are the templates for the summary workbook and the points workbook.
The final idea is that multiples of the points workbooks (under different student names) would be stored in the subfolders listed below. The summary workbook would take the student name and folder location AU1/2 etc, and use this to tabulate data from a specific cell of each points workbook.

Currently the folder set up is as follows:
2018-2019 ->
-Autumn ->
-AU1 -> Subfolders
-AU2 -> Subfolders

-Spring ->
-SP1 -> Subfolders
-SP2 -> Subfolders

-Summer ->
-SU1 -> Subfolders
-SU2 -> Subfolders

Many thanks in advance for any help or pointers I may receive.