Copy paste loop Multiple sheets column wise

[maheshwaran]

Evening all,

Would anyone happen to have a copy paste macro which loops through multiple worksheets within a workbook?!

I have 30 worksheets which I need to copy data from, before pasting it into a worksheet entitled Master.

The range will always start from L10 to L30

Ideally I'd like the macro to copy data from sheet1 and paste it into the Master worksheet in say A1, then loop through to sheet2 copy the data and find the next empty Column in the Master sheet and paste the copied data, and so on and so forth.

Any help would be much appreciated.

Thanks in advance.

[snb]

Are you familiar with the macro recorder ?