macro that will insert rows base on a cell value

Hello to all,


I am a newbie in excel macros and i do create macros by just recording. Need to create a macro that will insert number of rows below a cell base on its value, then copy a range of data in a row and paste it on those rows.
Attached is the sample file with two tables. The table below is the one i want to accomplish. thank you for your help.

table.png