I have a master worksheet that pulls data from other worksheets in the
workbook. I want to copy those formulas to other workbooks which have
different text in them so I can't just make copies of the original file.
However, I don't want the target workbooks to refer back to the original
file, only to the same worksheets within each workbook that the original
workbook referred to. How do I do that?