if you have one master sheet, and seperate report sheets look at vlookup against the name utilise the colum select to give the required results

or the equals function to cross link popupale a different sheet

Couple ideas to look into