Search data in one Column, display data from lower down the same column.

Thanks for thye Reply. I havd done as you instructed and uploaded a small sample of my Worksheet.

what im after is as you update the table on the left information from there is automatically added to the one on the right. as i said before the engeneers names will not be static, they will move around so i need a formula that
will search colum A and then input the data below it into the table on the right. ie, the site where kieth is working is minworth so as keith is added to the board on the left, it updates the job hes on, site hes on and job number accordingly.

again, thank your for your help.