Hi all, i am new to forum posting so please be gentle...you are my last hope!

I have a master workbook, (containing only a single worksheet) that has been set up to mirror the structure of 18 other workbooks, (also containing a single worksheet) saved in a specific directory folder named 'Source WB'.

I need some VBA code to retreive specific data from the multiple workbooks in the 'Source WB' directory and then consolidate to the master workbook. So for example, i need the data in cell D7 in all the source workbooks to be added together and the sum populated in the corresponding cell in the master workbook. All the source work books have slightly different names begining with 'Source' and I do not want to open the source workbooks to acheive the desired result. There are also other workbooks in the directory who's names do not begin with 'Source' which i would like the macro to ignore.

I attach three example workbooks to better explain:

The code has to look in the directory 'Source WB' to find the relevant workbooks who's name begins with Source. Then go to cell D7, sum the total for all source workbooks and return the result in cell D7 of the master workbook and so on for the remainder of the selection, (highlighted green in the examples)

I hope i have explained properly as I have searched this forum and found many helpful hints that come close to what i want but i have been unable to find or acheive exactly what i need.

Many thanks to anyone that can help.
Master.xlsx Source One.xlsx Source Two.xlsx