Macro to select multiple Workbook and copy Data

I have a macro below that open a workbook and copies the data from sheet1 cell A1 to last row in Col K) pastes this on to sheet ("Imported Data") cell A1 onwards

The macro works where only one workbook is opened


I would like the macro amended so that it will allow me to select multiple workbooks to copy the data from sheet1 and to paste these one below each other oo sheet ("Imported Data") cell A1 onwards

Please Login or Register  to view this content.

Your assistance is most appreciated