I wish to copy a formula to another workbook but need to break the link so
the formula refers to a worksheet by the same name in the new workbook ie: I
wish to paste a worksheet containing formulas into a number of other
workbooks and that new worksheet has look-up formulas that refer to
worksheets of the same name in each workbook.