I am trying to copy of a worksheet into a new file but receive #REF errors on
the new workbook when I do. I believe the cause of the problem is the
following formula:

='21day wksht'!$F$3+(IF(ISERROR(VLOOKUP(B3,INDIRECT("'"&B3 72&"
Update'!$A$7:$L$43"),12)),VLOOKUP(OFFSET($B$369,-396,MATCH(1,$B$369:$V$369,0)-3,1,1),INDIRECT("'"&OFFSET($B$369,3,MATCH(1,$B$369 :$V$369,0)-3,1,1)&"
Update'!$A$7:$L$43"),12),VLOOKUP(B3,INDIRECT("'"&B 372&"
Update'!$A$7:$L$43"),12)))

Because of this formula, everything else based off of this cell becomes a
problem. Why does this happen? It's simply referencing everything back to the
old worksheet is it not? Plus, I designed the macro so do the following:

1. Create a copy of the sheet into a new file
2. In the new sheet (if things don't come up with these #REF errors), copy
paste special values.

Let me know if this a common mistake. Thanks so much for all your help in
advance.