populate list on one tab by taking rows from another tab only with data in certain columns

Hi all - thanks in advance for any help on this:

I want to setup the tab "Item Format" so that it automatically populates from only rows that have data in AA through AG on "Worksheet". The "worksheet" tab is set to include data in columns AA through AG only if the value in column H is within 60% of the value of H3. So the rows that will be included in "item format" will change depending on the example's value in H3.

For instance, in this example only rows 5 and 9 have data in AA through AG because H5 and H9 are within 60% of H3.

So in this example 'worksheet'!AA5 should populate 'item format'!G7 and 'worksheet'!AA9 should populate 'item format'!G8.

Cheers

Glenn!! This worked beautifully - thank you.

I am curious (and not an excel expert): why does the function reference H4 for the cost/ GSF? It works beautifully, but I'm not sure how we get the function on the "item format" tab to parse the data by the building cost/ GSF when the worksheet tab uses the GSF to decide if the data should be shown.

At any rate - thanks again. I really appreciate it!