Inserting rows of data onto another sheet, depending on a value in one cell on another.

Hi,

If anyone can help on this it would be appreciated as I am lost on macros.

I am doing to putting together a deliverables list to help me put together quotations for projects.

The idea is on one sheet were I have a list of things to deliver, I put in a quantity.
Then on another sheet it populates those things including the amounts of each item onto a separate row.
However it does not include those things which do not have a quantity next to them on the first sheet.

I've probably not explained it that well to so to help explain it I have attached a draft copy showing the first sheet "project norms" with the quantities in column E. There is also a "before" sheet showing before the values were added and an "after" sheet showing once they have been added.
Note on this sheet the headings move down to make i.e.ED-01: Sub Totals.
Also with the rows inserted, some of the cells have values copies over too, i.e. Base Hours, Start Date & Finish Date.

I've seen it done with a macro on an older version of excel and there was a "activate" type button on one of the sheets, which did the auto fill. And that's about as far as I got into macros.

Again I'd appreciate the help.

Faulkes 2