Hi

I am trying to create a macro or VBA script where I can remove the data stored previously and then automatically populate it with data stored in another workbook.

Apart from this also looking for macro where I can club data from many workbooks into a single workbook and same sheet.

Thanks a tons!