We have 5 projects going on, so I've created 5 different worksheets to track
them. My boss would like an "admin" page. This should look at all the other
worksheets and add the employees time together, if over 100% then they would
have 0% for admin, if less than 100% then the admin would be 100-(sum of the
5 worksheets).

My problem is that one employee could show up on everyone of the projects or
on just a few or none at all. The complication is that the employee can be on
a project more than one time (once for Capital and once for Expense). I have
to add the time for the employee together (for all the worksheets and both
Capital and Expense). I'm at a loss. Any suggestions? Here's an example of
what I'm talking about:

Project 1
John Doe - Capital - 32%
John Doe - Expense - 25%

Project 2
John Doe - Capital 15%

Project 3
John Doe - Expense - 20%

Project 4
(John Doe doesn't work on this)

Project 5
(John Doe doesn't work on this)

I need to have the admin page look like this:
John Doe - 8%

Any suggestions are appreciated!
Thanks,
Chris