Formatting the Data with VBA code

[AVG123]

i have a excel workbook and it contains 2sheets i.e. sheet1 and sheet2 which is also attached herewith for ready reference


i want a vba code to add 10 blank rows before the First #N/A of Col-H of Sheet1 (first #N/A exist in H16, add 10 blanks rows before H16)

after that i want to add the data which is exist in Sheet2 "Col-A2 to G2" and put it after H15 in Sheet1..........after that make a total of Col-F in the very next row