So I'm tasked with a recruitment spreadsheet and I'm finding it difficult to get a formula to collect all candidates that are appointable onto a summary page. I have 4 tabs Nottm, Northants and Leicester. In these its broken down into tables with interview info. If someone is successful in column N we will put "Yes" all I want is to then get their name from the respective row to appear in the name section of the summary page which is Column D.
This would have to gather all 'Yes' names from all tabs so we can then track their recruitment