I run a hockey draft that requires me to copy worksheets into a master sheet
but I need to know how to copy them without the formulas referencing the
workbook that they came from as the formula will only work if it stays
general. i.e. =IF('MasterI12'=1,"Correct", "") rather than
=IF('CopyofSheet4MasterI12'=1,"Correct","").

Right now I have to doa search and replace on every sheet I copy into the
master sheet and it is very painful :(

Thx.