Linking cells in one worksheet to another that can be sorted

I have a workbook that contains a master sheet of residents in a condo association with personal data, one utility worksheet for lists, and 46 individual account worksheets (one for each resident). I...