Linked dynamic ranges
 

I'm trying to create a scenario where I have a master list of names on one
sheet, and on secondary sheets, the same names, but filled with different
data pertaining to that person. The problem I'm having, is that if I delete
a name from the master list, the seconday sheets show #ref error. I'd like
for the list on the secondary sheet to expand or contract (with the
applicable attached data) accordingly. It seems like a basic problem, but
for some reason, I'm stumped. Any suggestions?

-Djeung