Copy Cells to another sheet based column criteria

Hello, and forgive me for being such a newbie at coding.
But I am seeking some help as I have struggled with this for quite some time.
I have a Workbook with two Sheets (Sheet1), (Sheet2). On Sheet1 I have details in each column (A,B,C,D,E), and a qty in Column F. What I am attempting to do is, if Column "F" has a Value > 0 then I would like to move the Data from each Column (A,B,C,D,E) for each line only that has a Value > 0 in Column "F" to Sheet2 and paste special in the respective columns starting at A16 and ending at A40 as I have data above A16 and below A40.

Thanks in advance for any help you can provide.

This can be done. However, what if the data to be copied crosses row 40? How do we tackle this?

Why is it that there are blank rows between row 16 and 40?

There should be no data copied across row 40. Maybe I should have explained the sheet functions a little better. Sheets1 is a list of available options, while sheet2 is a quotation sheet. there are only 24 possible combinations, so therefore only 24 lines are required. Start Rom A16, Finish Row A40.

Can you please attach a sample workbook and i can help you out.

Thank you for the help, I have attached a sample copy of the workbook.
I have a code installed that will generate what I need and not exceed line 40 but I really need it to paste the row columns found with value > 0 with paste special value to each individual cell as the Quotation Sheet has merged cells between A16 and A40.