I am trying to figure out how to pull in the Name, County and Status from a master list onto a new sheet based on the master's Status column containing data. I am wanting to do this so that we are not overlooking anyone. I have been trying to figure it out and have seen that I probably need to use the INDEX and COLLECT functions but I am having a hard time figuring out how to make these formulas work with cross sheet references. Anyone able to help me figure this out?
Edit: these are sample sheets as my others have sensitive data on them. One other important piece of information is that some Statuses in my true master list are empty. I would like to have this formula pull only rows containing information as opposed to all of them. Did not think to show that difference when posting original screen shots.