copy data from 40 sheets to one consolidated sheet in different columns

[N Prakash]

Hi,

I have 40 different sheets of data and data is in column A only in each sheet. I need to create a consolidated sheet by copying data from each sheet (Column A only) to a different sheet in 40 different columns. I was looking for Macro code and I was unable to find one. Can anybody help me please.

Thanks in advance,
Prakash

 

[Fluff]

Glad we could help & thanks for the feedback