Array used as a Data Validation List

Is it possible to create an array that holds the names of all the visible worksheets in a workbook,
then use this array as a Data Validation List for a range of cells?

I know how to code a List box, to list all of the sheets,
but I’d rather have the user pick and choose from a drop down list in each cell.

After the user makes the selection, three other cells will be populated with data
from named ranges on each sheet.

I’ve include a workbook for illustration.

Thanks.