Index to Pull Rows from Multiple Sheets Based on Cell Within Row

[Mattman121]

I am creating a master sheet to analyze 6 other sheets in a workbook. All the sheets are formatted the same and have the same layout. I am trying to pull the entire row if one the the cells values is 0.

I have used an index small feature before to do this with a single sheet but do not know how to do it to search multiple sheets and extract the row.

Attached below is what the sheets I am pulling from look like. If the the cell in the 6th column is 0 I want to pull the data through.

Thank you in advance!

Matt

 

[Mattman121]

Not sure why the picture didn't pull. It can be found here. https://pix.sfly.com/Mp0tH6