I need to copy a worksheet that links to cells in another worksheet in the
workbook. This worksheet will be copied to 300 different excel files which
all have the same format but different data in the cells. Therefore, the
worksheet that is copied to the a specific workbook must link to the workbook
it is copied to and not the workbook it is copied from. How can this be done
with the least amount of effort? (Excel 2000)