Combining all tabs into one tab - problem with code

[orhanceliloglu]

Hi Everyone,

I am making a code for combining my 8-10 tabs into one tab which is called "Master"

Until now, below code is working. But its working only one time. Creating a tab called "Master" taking the all other tabs with column names etc. When you add something to your original columns and try to run the macro again, it's giving an error and saying there is already a "Master" tab.

So, my question is how can I fix this. I need to edit the code and make the update on the Master tab itself. Basically, it should have to overwrite the previous version or delete and make an another combine data.

I would be appreciate if someone can help me on this.

Thank you very much
Orhan

PS: Please find attached sample excel as well.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[orhanceliloglu]

It worked ! Thank you so much

[sintek]

........deleted......................

[TMS]

Perhaps:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and reps.