Index Function with Named/Defined Ranges

Pulling my hair out over this one...

I have a master sheet (Tech Counts) that lists hospitals in column B and the workgroup each hospital belongs to in column A. There are several other columns that irrelevant to my problem.

I created dynamic name ranges for each workgroup so as I add new hospitals to the workgroup I don't have to manually update the range. The "Index" sheet, pairs the workgroup number in "Tech Counts" with the appropriate defined name.

In the "Report" sheet I set up validation in cell F5 to allow me to select a workgroup from the Index sheet. In cell A10, I have created a formula intended to use INDEX and INDIRECT to pull the first hospital in the workgroup I select. As you can see, I get a REF error. However if I simply type =INDEX(Detroit,1) I get Childrens Hospital of Michigan (the correct answer).

Can some take a look and help me get the correct answer by using the dropdown?