I was hoping to have a formula similar to the one I have posted. This way it
can go into the main folder, look through all other folders, find all report
cards, and sum the value at the address so that I can have a grand total
carried to my data base.

Is this possible?

Test 1 through 3 are folders all containing 1 file called 'report card'.

Although called Test, these folders are actually different peoples names.

=SUM('C:\NORTH BAY TIMMINS\TEST1,TEST2,TEST3\[REPORTCARD.XLS]Report
Card'!$D$14)

I wish to have a formula that will go into all the sub folders within a main
folder and look for the file called 'Report card' and then sum the values
from the above cell.

Any help would really be appreciated.

-Bad