I want to copy a worksheet names WK 15 that has several formulas in linking
to WK 15 of other sheets, then paste it to create another workbook but
changing all the formulas to WK16 and not WK15 but keeping all of the other
data within the pasted formula the same.

EG: SUM('Y:\AREA\PARADE\[WK 16.xls]Sheet1'!D$6) and various similar formula
to be copied and paste onto a new workbook but change [WK16.xls] to
[WK17.xls] only within all of the formula so I do not have to keep manually
changing each cells formula myself.