Taking elements from a table dependant upon values

Hello,

I currently manage the spare parts at the company I work for. This includes ordering parts when required, based on when we expect to run out. I have created a sheet (as seen in the attached image) that calculates when we are expected to run out of a particular part based on the average monthly consumption, the current stock level, and how long it will take to receive a part from the factory.

I have been asked to set up a separate sheet specifically for ordering parts, what I would like to know is if it is possible for me to pull parts of information from that table and place them in another, based on whether the reorder column (see image) says "yes" or "no".

Thanks in advance for your help, any input would be greatly appreciated.

Assuming your table in A139 to K145, then in L139 enter formula

=IF(K139="yes",count(L$138:L138)+1,"") and copy down.

in M139 enter =MAX(L139:K145)

In the other sheet, then

=IF(ROWS($A$1:$A1)>'Sheet1'!$M$139,"",INDEX('Sheet1'!A$139:A$145,MATCH(ROWS($A$1:$A1),'Sheet1'!$L$139:$L$145)))

copied down and across. Where Sheet1 is name of your database sheet.