Combining columns across sheets and workbooks.

Hello Everybody.

What I am trying to do is take four columns and turn them into one.

Column 1 Column 2 Column 3 Column 4 Column 5

AA AA BB CC DD
AA AA BB CC DD
BB
BB
CC
CC
DD
DD

However, each of these columns is on a different sheet.

Furthermore, I will then need to take this 'super column', column A and combine it with others from other workbooks. I have been hunting around all over but can't find a solution. I can find a solution when it is all on the same page but not across sheets and workbooks.

Can anyone help?

Thanks

L

Column 1 in A
Column 2 in B and so on

Column Overall in F

F2: =a2 & "-" & b2 & "-" & c2 & "-" & d2 & "-" & e2

and then copy down

you will get: AA - AA - BB - CC - DD