How to get text to automatically appear in a cell.

I manage rental properties for my job and I am trying to create a spreadsheet to monitor repairs.

It my first column, I have a validation list for the area. In the second column, I have (using the indirect formula and validation) another list of all of the properties we manage within the chosen area. Once a property has been chosen, I want the next column to automatically pop up with the tenants name and the following column to automatically pop up with the tenants phone number. I have all of the date already set up in a table., just need to work out how to link it all together? Please help!