Hey all,

Currently i have macro that opends up 10 different Workbooks, copies a range of data from each Workbook, goes back to the main Workbook, and Pastes it into that workbook.

I have got it working but it is really slow.

is there a way to get data from a sheet in a workbook without having to open that sheet and copy and paste? eg set up a macro for import external data?

any help would be great

Thanks

Tom