Urgent help for excel formula

Hi there, does anyone know what formulae I can input on the right table to easily track these data from the left table and input them instantly on the right table based on the various names (especial...