Matching Data with set requirements

Hi Experts,

I have a spreadsheet that is capable of assigning names to postcodes based on set requirements but I have now come to a point where I need to reduce the input by users. is it possible to create a formula that works in three stages

Stage 1 - Identify which company (Column D) is working in the postcode given (Column B)
iferror(VLOOKUP(C7,(INDIRECT("'" & B7&"'!$A:$L")),9,FALSE),"") is the formula I used to look at
each companies page

Stage 2 - Looking at the Companies individual sheet (ie where CO 1 is listed, look at sheet CO 1), Identify which staff members
are available by them having an X in the day of the week that matches sheet AUTO ASSIGN CONTROL (in this instance Friday)

Stage 3 - Match the names available to the relevant postcodes, my previous formula required
4 sleeper columns using range F:I, the formula in Column E was then able to use one of the 4 names
without duplicating names

This sheet has come along way but I need extra input, I have attached the file and in yellow I have manipulated the data where the new formula should be but I can not seem to solve it.

Any input would be great