I'm tracking applcations in a report I send to various managers. Each
application has its own tab (ex. ABC, CDE, EFG, HIJ), but not all tabs will
be present for each manager.

Manager A's workbook might have ABC, CDE, and Manager B's might only have HIJ.

I'd like to create an index tab that will lists all possible tabs and
indicate with a YES or NO whether or not the manager has that tab listed. Is
there a way to do this?

For example, Manager A's index would look like this:

ABC YES
CDE YES
EFG NO
HIJ NO

Manager B's index tab:

ABC NO
CDE NO
EFG NO
HIJ Yes

Thanks!