I am refering to example 2 in your sample file

"Chirag Ruparelia" wrote:

Hi All,

ron de bruin merge data macro was very helpful for me. But need a help to
make certain change in macro.
I was trying to Merge a range from every workbook you select (below each
other) but it works only for 1 sheets.

Please could you provide me the code in which 2sheets are together merge in
to separate new sheets.

I am not much fimiliar with the VB coding

Your help would be much appreciated!!!

Thanks,
Chirag