how to copy paste cell to 1 column to line 200 by repeating the data copied with VBA on exel : [the first image is my data which is 1 column 10 lines on sheets 1][1]


[the second image is after I copy paste from sheet 1, which I ask copy paste from data 10 sheet 1 copied to sheet 2 in column 1 to line 200 by repeating 10 data in colom 1, can you help me?
][2]


  [1]: https://i.stack.imgur.com/lkUvO.png
  [2]: https://i.stack.imgur.com/QKCbz.png