Hi Sanju,
Two options
1) if all the files are exactly the same you can summarize them in your
destination file
=sheet1!A1+Sheet2!A1...

2) see Ron macro

http://www.rondebruin.nl/copy2.htm
http://www.rondebruin.nl/copy3.htm


"sanju" wrote:

Please can you help me how can I merge all the excel files to a new
different worksheet named destination.
All the files are of the same format having same columns.

regards
sanju
.