copy a worksheet to new one with repeat rows 5 times
 

I have worksheet with 1000 rows.
i want to copy it to another one with repeat every row 5 times and put a
certain different values in column B every 5 times like:
B
32
42
654
76
4
..
..
..
32
42
654
67
4
and so on