Reporting form

I am relearning excel... it has been a while, please bear with me...

I am putting together a spreadsheet to report issues across a site.
Each location (list A) within the site has an associated key worker (list B).
Issues reported are usually for each location by their key worker, HOWEVER it may be via a third party Reporter (list C)
Lists A, B and C exist on a separate worksheet within the same workbook

I have the Location column in the reporting worksheet linked, via a drop down list to the list of the locations in the second work sheet.

I want to Pick a location and populate the next cell automatically with the key worker - however I need to be able to change that 'name' to another person from the list.

Could anyone please advise?

Many thanks