Sum cells from multiple files in same folder

[tripp]

I have multiple excel files (file number varies but now it's approx 30) in one folder location. All of the files are formatted exactly the same. Only the file names and cell contents differ.
Is there is a way to sum (or get) the values of the same cell and/or range in all of the files into a new excel file worksheet?

Example: Sum or get value in cell "A1" from Sheet1 of all files in C:\excelfolder.
and
Sum or get values in range "A1:B2" from Sheet1 from all files in C:\excelfolder.

Thanks for any assistance.

 

[Worf]

Mr. Bond

As Kenneth said, you will have to sort by some table field (column), currently existing or to be added.
Please tell us which one and if you need help tweaking the code.
Can you describe your table? The important thing is that each table record (row) is consistent in itself.
Maybe we should move to the other thread…