Lookup or Index & Match Maybe?

When I open the red cell on each bracket (i.e. C6), I want to select an “Open Table” from the drop down list.

The VLOOKUP doesn’t work because it needs to look in an array (C6:I34) on each bracket, not just one column.

We will be assigning tables in 2-3 different brackets simultaneously, so when Table 1 is selected in a cell one bracket, it should not show up on the drop down list when we call a table anywhere else on that same bracket or any other bracket…..UNTIL the match is over.

So when you double click on A5 or A7 for example, I need it to copy that value to D6, AND it also should add that table back to the “Open Tables” list. Same for A9 & A11 copy to D10, etc.

I feel like I’m close to making this work but I cannot get over this hump. Any help would be appreciated!!