My company has asked me to set up a quantified evaluation for each employee.
My parameters a phone calls, work produced and errors, checks requested,
and accounting submitted.

I am dealing with 70 employees over 5 teams, each team handling multiple
clients. Each person's stats are gathered on a daily basis, and will need to
roll up by client and team, and then into individual evaluations as well.

Is there an "easy" way to do this so that each year I don't have spend a
month manually creating all these formulas and links? Also, any suggestions
on the best setup for the daily data so it's easier to pull into higher level
spreadsheets?

Thank you all in advance :)