OK..here we go!!
I've created a marco for you.
Add it to a module and attach it to a button and run it.
- It goes into your store 1 sheet
- Applies an auto filter
- Filters the status column to only show completed or fabricating
- Copies from the PO column ( C3:C10000)
- Returns to your summary sheet and pastes them into B5 downwards
- Highlights the B column and removes any empty cells so there are no gaps.
I added that last point in as you said you had 8 sheets, so there would be gaps using my above method.
But the last point removes this problem.
Just make sure you have
At the end of all 8.
Addtionally you may want to increase/decrease the capture range