Copy a row and paste it a number of times based on a cell value

Not being a VBA expert, I hoping someone can help me. I've found several examples of things that are close but I haven't been able to modifiy anything to work.

Here's what I have -

In A4:T4 I have columns with calculations to perform and that I need to repeat on multiple rows based on the value in B2.

In other words, If I have the value "5" in B2, then I want to copy A4:T4 and paste it 5 times, on the following rows A5:T5,A6:T6,A7:T7,A8:T8,A9:T9,A10:T10

It would be nice if it would also clear the added rows when I change the number in B2 so if I went from 5 to 2, I wouldn't end up with clutter. I can have as many as 100 rows in this spreadsheet.

Here's what I've been doing manually that I'm trying to adjust to work as I described

Where do you want to copy the added rows? Is it on the same sheet, or new sheet? How many rows do you want to copy? Is it a single row, or all 17 rows?

Assuming you want to copy all rows. The result is in sheet2

The result can be on any sheet but the result would like exactly like the sample. Enter the starting number and the number of codes. THe first detail line is replicated to match the number of codes, the column called "Numeric Value" is incremented by 1 until number of codes is met. the end goal is to calculate the check digit for each mumber in the sequence.

Starting Number 07874205660
Number of Codes 3

Text Value Numeric Value 1 2 3 4 5 6 7 8 9 10 11 Odd digits Even digits Even + Odd Base Check Finisher Check Digit Full Number
07874205661 07874205661 0 7 8 7 4 2 0 5 6 6 1 57 27 84 8.4 916 6 078742056616
07874205662 07874205662 0 7 8 7 4 2 0 5 6 6 2 60 27 87 8.7 913 3 078742056623
07874205663 07874205663 0 7 8 7 4 2 0 5 6 6 3 63 27 90 9 910 0 078742056630

Have you tried the attached?

I did, it gave me 3 duplicated rows on sheet 2 for every row on sheet 1

That is why I asked you which rows do you want to copy, is it row1 ,or2?