You can give this a look...
http://www.rondebruin.nl/summary2.htm
--
HTH...
Jim Thomlinson
" wrote:
I am trying to merge multiple excel files (that all have the same sheet
in them but with different data) into one pre existing excel file. Each
file has the same sheet in it but with different data. Do not have to
worry about data overwriting. I have seen something like this before
but can not remember how to do it with VBA.
Thanks!