Duplicate row based on a cell value

Hi, noob to the forum here, hope someone can help!

I'm looking for a way to duplicate a row based on the value entered into a particular cell, e.g. I enter '4' in the cell and it duplicates a specified row 4 times and numbers them sequentially. I would then like it to copy the entire section (tracker box, heading and row 1) below this to start over again.

So, like this:
-value entered in D6, 'number of items', duplicates row 10 (B10-M10, highlighted in green) that same number of times
-each duplicated row is numbered sequentially in cellB based on the 'number of items' (both highlighted in red)
-the entire section B5-M10 (highlighted in blue) is then repeated below to start all over again
8098070649_88ec360fdc_b.jpg

So the tracker would look like the image below:
8098070719_594327a0d3_b.jpg

As you can see, the row to be duplicated is composed of a mix of manual-entry cells and drop-downs -the options for the drop down are kept on sheet1 (Control) in addition to a copy of the tracker box, heading and row 1, all in the same positions as on sheet2- and i would like these options to be available in every repeat of the original.

Hope I have provided enough information to go on - and hope someone can help!

Edit: apologies, excel file attached

Please do not post pictures. Instead post the sample excel file.

*thanks arlu

i found the following which (i think) is part of what i'm looking for, can anyone help me build on that?

http://en.kioskea.net/faq/7546-excel...umber-of-times

Please Login or Register  to view this content.

Would you want the duplication and copying to be triggered by a button? Would you be having a button on your sheet so you can click on it ?