Merging Data from many workbooks in to one workbook

[Rajesh Kr Joshi]

Hi,

I got a macro code to merge data from diffrent files into one workbook. Currently when we run the code every time it make a new workbook and fetch the files basis given path. I wants, instead of making a new file it should update an existing file (I will assigne the macro to a button), and it should start merging the data from sheet2, because sheet1 is reserve for my dashboard.

Attached is the file with code.
Code source: http://www.rondebruin.nl/fso.htm

Thanks
Rajesh