I need to auto-populate a range of cells if criteria that is in a separate cell isn't met

I am working on a staffing/ attrition spreadsheet and want to automate a lot of it. I am hoping to get "OPEN" to automatically appear in the range of cells below any position that doesn't meet the "Needs" number in column B of Sheet1. I need this to occur in each position (grayed out area) in columns C, E and G. The "Needs" number does change, so I would like to make the formula rely on that number and be modifiable. I hope that this isn't confusing, because it is to me.

Thank you in advance!

Adam