Help finding data and returning in vertical cells

Hey experts,
I have a table with contracts names, post code area covered, managers name, plus some other items.

I want to have a sheet where I can type in a post code and have the installers data appear next to it. Essentially their name but other infor would be useful.

The installers postcode data contains the postcode or post codes.
An example would be, “B” or “BS” or “BA” or even “BS; BA & B”
I no cannot change the data to make it easier to filter through.

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

What I need to do long term is to have the managers call contractors, find out their availability and to enter it into a sheet.
The managers are responsible for areas of the country, and the contractor list is fluid.

Ideally I was thinking that they could select their postcode data from their named sheet (hence needing to extract the data) and have the contractors names appear against the post code area.
this would allow me to see where lead times are extended and we can recruit to fill this need, and collate a national picture for the sales team.

something like this

Postcode. Contractor. Manager. Lead time.
AB1 2CD Joe Hill. Manager 1 4 weeks