Unique site ID form selection list tht shows only availble site ID's

Hello, If possible I would like to get some help to finalize my excel sheet.
I would like to achieve to Select a unique SIDE ID based the country.
If a side ID is already in use, it is not showing anymore in the data validation list.
I have this working only for 1 country (NL)
But I hope to make the Data validation list flexible based on the country that has been chosen

In Column “b” on the LIST workbook, you select a country.
Based on this selection it is showing the selection list for a Unique side ID in Column C (Format is country code + LOC (for location) and a number between 001 and 999

As said I have this working for One list (NL), but when I get more and more countries It is not manageable anymore. My foist thought was to make it dynamic based on the Country chosen, But I don’t know how to change the selection in the Name manager based on the chosen country.

My WORKSHEET contains already 9 countries I would like to use (but this can grow in the future also)

Maybe this direction is not the right way either, so if you also have another ID it would be much appreciated.

Thanks for helping me out already.

Emoes

Hello Kaper,

I would like to thank you for helping me out.
I used this in my worksheet and it is working as I would like to have it.
Great that you spent some of your time to help out me (and others)

Kind regards, Emoes