I don't but someone may have.

You would probably need to use the FileSystemObject to iterate through the
folder and append each sheet of each file to a master file. I have not got
the time at the moment to write this for you, sorry.

i just need some research on this........

Have a look in Google Newsgroup search for "consolidate folder
multiple", without quotation marks.

Resulting page address below:
....google.com/.../search
olidate+folder+multiple+group%3A*Excel*&safe=off

First few hits should satisfy all your needs.