Thank you for your reply. It is a one to one relationship, the workbooks are not linked. I want to move the completed goals tab from the "evaluated" to replace the goals tab in the "evaluator" workbook.

I'm not sure what you mean by activate the function in the totals tab. When I copy the goals tab from one workbook to the other, the totals tab "breaks". I've looked to see if all I need to do is refresh the workbook somehow to get the totals tab working again.

The current workaround has been to copy and past each goal from the goals tab into the evaluator's copy.