Have you tried linking the formulas to the other worksheet? I doesn't look like something you would use to record multiple answers for multiple employees. If it's multiple, you'll need to assign a unique name to each evaluated person's spreadsheet, and create the formula to add all the spreadsheets and their specific cell content together in the Total tab. I haven't done this in years, and can't recall what the pitfalls are, but that might give you a starting point to see if you can come up with something that works for you.

However, if it's a one-to-one ratio, evaluated/evaluator, just activate the formula in the Total tab of the Evaluator spreadsheet, and click the appropriate cell in the Evaluated spreadsheet to record its contents, and it should work. You may need to tweak it a bit, but that's where I'd begin.