Lookup jobs belonging to a given client

Dear Forum (here I go again)

Please find attached workbook, which has 2 worksheets, (a) JobList and (b) JobLkUp.

So it would be antisapated that JobList would be a long list rather than just the lenght I have shown for just for the example. A given client would be expected to have many project over the years.

JobLkUp is what I want to try get working as a useful lookup tool. The idea being that the user would select a client from the dropdown in cell C1 of the JobLkUp worksheet, and that the relevant information would automatically populate rows 4 + (however many jobs that particular client has) for columns A:E.

Would seem the right formula in Column A (contract no), would allow for Columns B:E to be handled with regular VLookup, but I'm stuck on getting contract no.s in A4.

Any ideas?

Any insight would be great. Thank you.