Moving columns from different workbook into one single workbook in different sheets

[alex0403]

Dear all,

I am really new to excel. Here I have 30 different excel workbooks and each one has one worksheet. Each worksheet contains 30-50 columns and 130 rows of data. What I am trying to do is I want to copy and move the column A data of each worksheets into the sheet 1 of a new excel workbook and column B of each worksheets to sheet 2 and column C of each sheets to sheet 3 and so on. What do I need to do to make this happen? Do I need to create a Marco or something? If I need to use Marco, what is the code? Thanks!!!

[arlu1201]

Do you need to show the filename from where the data has been copied alongside the data?

[alex0403]

Hi arlu1201,

Yes!! If the filename can be shown on the top of each column, that will be great. Thanks.