This would work, so thank you. But I was hoping to not have to
hardcode in all of the file names. I was hoping to open a bunch and
then run a macro that adds up the cells from all open workbooks. Do you
think that is possible?

Thanks again for the input...

Jeff

somethinglikeant wrote:
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.