When text contains * and the adjacent cell is above 0 in multiple sheets

[Enounce]

Hi all,

I need your help with the following:

I have a spreadsheet with 7 sheets. On 6 of the sheets there's data entry, on the 7th I would like to summarize results. One thing I would like to show, is the text of all cells that contain * and where the adjacent cell has a value above 0. This is complicated by the fact, that I have 6 sheets it need to go over.

I'm quite sure that I need an array formula, and I've tried a few things, e.g. this, but I can't get it right.

Here's a Google sample sheet. Also added as Excel file now.

Thanks in advance.

[davesexcel]

just to confirm is this a goggle sheet or an excel sheet you are working with?

[Enounce]

It's a Google Sheet as we'll be sharing it between people.

Edit: The sample sheet is now also uploaded as Excel.