Merge All Sheet in the workbook in the last sheet with sheet name for each entry

[santoshsapre]

HI,

I have workbook having around 25 sheets and i want macro to merge all sheets except first (summary) in to last sheet ( mergedata ) inpute data will be start from cell A17 in all sheet. also sheets may be add or delete as per requirement. after merge data from sheet name should add after each entry .

attached sample file for your reference. pls help.

http://dl.dropbox.com/u/66400357/test.xlsx

[Pepe Le Mokko]

Use Ron de Bruin's Rdbmerge add-in