With 5 or less files, I would use a single formula. With more, I would use a
helper column:

In A1 thru A20 enter formulas like:

='C:\Temp\[visit me.xls]Sheet1'!$A$1
='C:\Temp\[second.xls]Sheet1'!$A$1
='C:\Temp\[third.xls]Sheet1'!$A$1

and then =SUM(A1:A20)
--
Gary''s Student - gsnu200795


"Jeremy" wrote:

I have a folder with about 20 excel files in it that I want to add all
numbers in A1 of the 20 files to a new excel file. What is the best way to
do this? I have a bunch of cells I want to do this with.

Thank you
Jeremy