I need help writing a formula that will link a workbook file with thousands
of other workbooks files by using a formula using a standard file name
convention.

Here is the standard file naming convention:

'W:\Projects\ &A169 &" " &B169 & "\Financial Information\Monthly
Summaries\[" &A169 &" Monthly Summary.xls]Sheet1'!$F$12)

By using this formula I would like to use the auto fill feature to update
the folder/file references.

I have literally thousands of excel files that i need this master workbook
to link to. Entering in the values manually will take far to long to do.

Please help