Copy rows of data on multiple sheets to one column

[imaguy77]

Hi,

Question for you all:

I have a workbook with a varying number of sheets, with a varying number of data in column A in each sheet. I would like a macro which will take all the data from each sheet in the workbook, and create a new worksheet which will contain all of that data, with each column containing Column A from each sheet. Column A = column A from the first sheet, column B = column A from the 2nd sheet etc.

Shouldn't be too much code, but i'm a newbie. Thanks for the help!!