OK - you've got your formula pulling values from various cells on sheet 3 based on what's in cell A9. Does A9 contain the validation? I'm assuming it does, and that the choices are:
"Wellness","Healthy Back Non-Incentive","Healthy Back Incentive","Open"

If the user choses Open in cell A9, do you then want the ability to edit A9 and put in some other value?

Right now your formula will display values from sheet 3 based on selection but will not "populate" other cells.

Can you clarify? Also, a mockup would be very useful...