VBA copy paste cells one by one

[Cime14]

Hi there!

I have data in column A (range is flexible) in Sheet1 and would like to copy each row to different sheet. Is this possible?
For example cell A1 from Sheet1 should be copied to Sheet2 (cell A1), cell A2 from Sheet1 to Sheet3 (cell A1),...
How to do this when range is flexible? Sometimes there are 20 rows, sometimes 40.

Thanks,
C.

 

[Joe4]

Are there always enough sheets to cover all the rows?
For example, is it possible that there are 40 rows of data to copy, but only 30 sheets in your workbook?
If so, then what happens to the last 10 rows if there is no sheet for them to copy to?