Merge multiple worksheet tabs into one in the same file

Hi,

Can you help me with a Macro to merge data of multiple excel tab in the same workbook.

Please find attached sample file where in the data is in multiple tab and new worksheet Final is made and data is pasted besides each other.

Thanks in advance

Akshay

Try the attached.

Thanks a ton, its working fine for me