Loop,
open each workbook,
copy the rows of data to bottom of destination workbook,
close current workbook,
next file
save current workbook

"Gunnar" wrote in message
...
I have by bad system design in earlier stage received about 500 pcs of
small
individual Excel files of exakt the same design but with data of different
items. Each file normally holds between 20 - 30 records (rows).
I now have a need to aggregate all these files into one single Excel or
Access file and would like to avoid all the work with to open each
invidual
file and copy and paste.
Does any kind person know any practical method available?