The info on other worksheet must be in table (all info about particular person is single row, the key column (e.g. name) must be leftmost one.

You can get any info for this person from persons table (e.g. part name) using VLOOKUP() function.