Pull data from multiple workbooks into one

Needin help wi pulling data from multiple workbooks into one. What needs to happen is that it copys certain columns from multiple workbooks and then pastes the columns into one master workbook, anyone tell me how to do this, had a wee look at the other threads on this but they dont seem to work.

Hello ro55co,

Welcome to the Forum!

To provide you with a solution, I'll need some more information.
1. Are the columns to be copied the same in each workbook?
2. Once the column is copied, where will it be pasted in the summary workbook?

Sincerely,
Leith Ross

Hey thanks for replying, i done a bit of playin around with excel and managed to do it.