Macro to auto fill rows based on one cell value

Hi,

I am trying to create a macro to insert and fill in whole rows based on where one cell has a value in it. I have a huge spreadsheet and need to create a summary one based on the items selected on it. So where a row is filled in with a number of items, it should appear on the other sheet, but not those where the number of items is blank. There is header/footer info so I don't want lots of blank lines which is why I thought a macro would be better than a formula, but I'm hoping someone with more expertise than me could advise!

Example attached.

Thanks (again)