How to add Row Data from one tab to another once a quantity is filled in each tab.

[Doug Jones]

Hello, 

I am stuck and I'm sure it's an easy formula. I have a workbook with about 16 tabs that have data in each row. and a master tab where I want to collect the data on depending on the quantity of each row. I have a column that I fill in the qty of each item I want to order and if the data is greater than 0 I want that entire row to auto-populate to the Master tab all of the material tabs will populate that master tab. I hope this makes sense. Please help! 

thanks, 

[#2]

@Doug Jones 

here is the link to the sheet. 

PO material.xls

[#3]

@Doug Jones 

If you're using Excel 365, perhaps this:

=LET(Stack,VSTACK(AllSheets),FILTER(Stack,(TAKE(Stack,,1)<>0)*(ISNUMBER(TAKE(Stack,,1)))))

The FILTER criteria is a bit longer because the arrangement of the data across sheets is not the same.  The header row starts in different places so a criteria had to be added so it doesn't pull text.

[#4]

this is exactly what I was after! thank you.

[#5]

You're welcome!

[#6]

Well, I broke it again. I'm getting an #CALC! error. I have been working to simplify my workbook and must have moved stuff around and broken the formula. any help you can give would be amazing!

[#7]

https://haggardeletric-my.sharepoint.com/:x:/g/personal/dougj_haggardelectric_com/ETr14RwxoF5On2Bw0X...

here is my link.