Would simply creating a formula work for you.

=C3(in JohnSmith.xls) +C3(...)+ ... + etc....

This would create links to all of your workbooks if stored in the same
place.

Need a bit more detail to get any smarter on this.