Merging different workbook into one workbook in different tabs.

[Jagdev]

Hi Experts

I am stuck with the attached macro and need your help to add few more features into it. Currently it is picking list of workbooks available in a default location and copy them one by one in each tab of the macro. Please help me to fulfill the following criteria.

• The Macro should create a copy named "Master" and perfrom the copy each sheets in tab one after the other instead of performing the same action in the macro sheet.
• In the current macro when I run it second time it creates addional tabs, is it possible for the macro to delete the old tabs and then create the new one.

Regards,
JD

[Jagdev]

Hi Experts

I find the fantastic link here - http://www.vbaexpress.com/kb/getarticle.php?kb_id=829, but it still do not fulfill the above 2 requirements.

Regards,
JD

[Jagdev]

Hi Experts

Please let me know your view on the above thread.

Regards,
JD