Reading Excel files in folder/subfolders

Hi!

I need some help reading out information from multiple excel files in folder/subfolders.
The structure of the folders are /year/month/file
So if it's a file from this month it would be /2014/Februar/test.xlsx
I need to read all the files within this month and next month.

I've attached a sample file which the information needs to be put in. under "Data" there's a table, i need to input the information from the files that are read.

From the source file in question

• Column A = C5
• Column B = C7 with a link to the file which it's from
• Column C = C110
• Column D = F16
• Column E = F10
• Column F = F7
• Column G = F8

Hope this is clear and hope I can get some input on this, I'm pretty lost unfortunatly :/
This has to be run when opening the "kalender.xlsx"