Why you want to do this? Why not simply to have a report sheet, where you select (using data validation list) a nursing home, and get there a list of residents in this nursing home (E.g. having in Roster table hidden columns where the numbers of every roster table row in one, and the number of record in roster table with name of nursing home equaling with the name selected currently in report sheet? This allows easily to generate in report sheet a list of all residents of selected nursing home there {a hint - SUMIFS() and INDEX() functions are, what you need to use}).