HI


I have a workbook designed as a performance review tool. It has multiple tabs with cells having formulas connected to a totals worksheet. Depending on the values assigned to these cells (mostly drop down boxes) the totals worksheet calculates an overall score. The problem, the person being evaluated and the evaluator are not the same person and these 2 separate workbooks are worked on by each individual until the time of the performance review when the two workbooks "come together" for the final evaluation. I am unable to move or copy the goals tab while keeping the functionality of the totals tab intact.

Can someone help and point me in the direction of how to do this: move or copy one tab of the workbook into a different instance of the same workbook and keep all the functions working. I've tried the usual, the move/copy tab with the source and destination workbooks both open, no glory. I've attached a copy of the workbook. Or any other ideas you might have.

thanks in advance