Keep manual row data

I have a spreadsheet with 4 tabs (Questions, required, recommended, formulas). Based upon how a user answers the questions on the questions tab, it will updates items on the formulas tab to Required or Recommended. I am using the Filter Function to spill data from the formulas tab to the respective tabs(Required/Recommended) based upon the results of the formula for each item. The formulas tab will be hidden from users.

My dilemma is on the Recommended tab I have added a manual column that has a data validation list of Yes/No. I want the user to be able to select if the recommended data listed in A1,A2, etc should be required.

The problem is if an answer on question tab changes it can change the output of what is recommended. The Filter function works great, but the answers they selected in the manual column will be incorrect because they do not dynamically move with the filtered data. Just trying to figure out how to get the manual data to dynamically update as well.

Apologies for the long post.