Copy and Paste With Name Change Using Cell Value

[jbold2]

Hello Everyone,
Your help would be greatly appreciated. I am looking for some code that would copy some specific rows and paste them on the same sheet, one below the other, equal to a number put in a separate box. At the same time I would like to rename one of the cells in each copied groups. For example:
A1=3

Original
XXXXX =Name1
YYYYYY
ZZZZZZ

Copy
XXXXX =Name2
YYYYYY
ZZZZZZ

Copy
XXXXX =Name3
YYYYYY
ZZZZZZ

Any help with this would be so great.
Thanks!!!