Inserting rows based on entered value

Hello,

I am working on inserting 1 to X amount of rows based on user input. Ideally I would like the user to be able to enter different values in A1, A2, A3, etc and then a single macro/button used to insert the appropriate number of rows below the number that was inserted into column A. I want the program to repeat for the number of values entered into column A.

PLEASE help!

Thanks,
Terra

EX:
NO. OF OUTLETS TAG - FL - AC - # (N)/(E) RH/CO

3
1
2


Produces:

NO. OF OUTLETS TAG - FL - AC - # (N)/(E) RH/CO

3



1

2

Thank you so very much!

This was exactly what I was looking for.

Best,
Terra