Copy then paste/insert X number of times

Hi,
Im trying to figure out a way to make a packing list/ bill of materials one a list on one sheet.
Im not sure how best to explain it so have made a sample excel file to illustrate what i mean.
On the first sheet the items are entered and on the last sheet the packing list is built.
I would prefer to use formula's if possible and think the easiest way would be to buildthe info i want copied on another sheet then copy or insert it the right number of times to create the packing list.
im sure I havent given you enough info but Im sure youll let me know what I have missed out.

Thanks for your help
Cheers
Steve.

John,
Thanks for that, I think its part of the way.. but if I change all the qty's to 3 I dont get the right result.
If i could get the item number and description to jump to the packing list ok then I could probably pull the other details in using vlookup quite easily.
Its just that with functions I have a better chance of being able to tweak it as I know nothing about VBA
Cheers
Steve

John,
Thanks for all your efforts but the new version doesnt do the required at all.. it just seems to repeat sheet 1.

Cheers
Steve

John,

"If i could get the item number and description to jump to the packing list ok then I could probably pull the other details in using vlookup quite easily" meant if Example book 1 worked wonderful, if not Example book 1 could at least build the packing list with item numbers and description then great.
Meaning as example 1 but just the firat two colums no need for Colour Material and age ... as it just makes it more complex...
Am iI confusing things ?

Cheers
Steve.

John,
Thats perfect,all i need to do is try and understand which bits of the VBA point to which bits of the sheet.
I dont understand VBA at all sorry.
Ill have a look at the VBA and ask,try to lean if you dont mind.

Cheers
Steve