When I try to use Find/replace to replace the worksheet name to formula's
linked to many different workbooks, but the worksheet name is the same. It
gives us an update values box with the file name and wants us to locate the
files.

Ex: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div Auditing.xls]SEP'!$E$39
(It is for multiple files and folders all under BSP Auditing.)

Want to change to: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div
Auditing.xls]JAN'!$E$39