Hi,

I have multiple workbooks which has only one sheet. The sheet has many columns. What I want to do is to take the whole of Column A from multiple workbooks (1,2,3,4,etc) and put into one master workbook, with those column A (from workbook 1,2,3,4,etc), arranged column by column.

Same for Column B from the same workbooks, copy data from Column B and put into the different master book. Same goes for Column C and so on.

Is there a way to do it?