Good morning,

I have a directory with several hundred small excel documents (a Db export into excel files). However I would like to merge each document into a single main document, keeping each document in its own worksheet.

Does anybody have any references where I can get a macro that will do this?

Everything I search, all I find is how to copy data from one worksheet to another.

also, these files do change periodically, so a dynamicly reading code would be awesome. All the files are in 1 directory however, which should simplify the process.

Thanks in advance,

Spyrule