I've currently attached the Excel workbook that I am trying to use for this. If you click on the first tab, named Card, you can see that I've organized some groups with names. Ideally, there would only be one cell which would contain all of these sheet names, and, depending on which one you select (from a dropdown), it would change the list values in a second dropdown which would be based off of the Person row in each of the sheets.
I'm also running into another issue where Ignore Blanks isn't working. I tried including a sample dropdown.
|