Insert data row and copy content

[adam]

Hi anyone,

The current code in the attached workbook inserts rows above the number selected from column F of the sheet 1 to the sheet 2.

How can the code be changed so that when the macro button is hit it inserts a row in between row 8 & row 9 (of the sheet 2 )and copy the (Sheet 1) contents from the columns F, H, K, M, N & O to the columns A,B,C,D,E & F of the sheet 2.

I hope I've made my question clear.

Any help on this would be kindly appreciated.