Sum all workbooks in a folder

[excelgs]

Please help!
I need to sum a particular column in 222 workbooks (all within one folder), and have those sums listed in one column of a new workbook.
The folder path is H:\ST\Sum and I need D2: last row (varies). I want it to put the sums in column A of a new workbook.

I don't want to add all the sums together as I need to see various measurements of those sums like lowest/highest sum and average of the bottom 20% and top 20%.

Thanks for any help!

 

[Michael M]

Ron deBruin has instructions and code here...

Merge data from all workbooks in a folder

 

[excelgs]

Thanks! I had seen part of that info somewhere else but this one had a better explanation as to what parts I needed to change to fit my data. It worked!

 

[Michael M]

Excellent......