Copy data from specific sheets from one workbook to another
 

I'm new to programming in Excel and I have a specific project I could use
some advise on.

I have a need to be able to copy specific columns (qty. 3 - 10) from
specific worksheets (qty. 5) from one workbook to another.

So my data will come from something like this,

SourceWorkbook
Sheet1
Column A
Column B
Column C
Sheet2
Column B
Column E
Column G
Sheet7, etc. etc.

The columns will always be in the same locations within the specific
worksheets, but the workbooks they are in may vary. I need a way to pick the
workbook I want copied from.

The destination workbook, sheets and columns would not change from each
execution.

Can anyone recommend a resource on how I can figure out how to do this? Or
if it is even possible?

Hope this makes sense.

Thx.

mtuohey