Extract entire row when condition is met & create a funnel between the tabs

I believe that the way to overcome the issue of changing no to yes for 245-05 is to have all of the decision columns on tab one as modeled in the attached file.
I used the older INDEX based formula as the FILTER function isn't supported by my 2019 version, however I imagine that the same results could be obtained using FILTER.
Note that to get the data for 245-05 passed to Tab3 a "Yes" would have to be entered in cell E6 in Tab1.
Let us know if you have any questions.