Good Morning,

I have a data base titled 'DISTRICT YEARLY ROLL-UP'.

This data base looks in a folder called 'NORTH BAY TIMMINS' for the name
'MARTIN114' and looks inside this folder for a file called 'REPORTCARD.XLS'
and finally reads a file called JAN at the location provided below.

=SUM('C:\NORTH BAY TIMMINS\MARTIN114\[REPORTCARD.XLS]JAN'!$D$14)

My question is the following;

There are more names than just 'MARTIN114' in the folder and I wanted to be
able to have my data base read the report card of all names at that location
(JAN'!$D$14)

Is there a way to tell my data base to read the values at JAN'!$D$14 from
all REPORTCARD.XLS from all folders within the 'NORTH BAY TIMMINS' folder?

Thank you in advance :P

-Bad