Hello machirajun,

Welcome to the Monastery. It was a few days ago a recent question was asked and I wrote a script for it. Take a look here Re: Merging 2 xlsx files (UPDATED), maybe this shouts your needs, since is able to handle multiple sheets and multiple documents.

Hope this helps, BR.