Is there any way to dynamically name cells in order to create unique
indifiable cells. I specifically want to name cells based on joining 2
idenifiers found in a worksheet (i.e. I want cell H1 to be named EBI_130,
cell H2 to be name EBI_131, etc.)

I haven't figured a way around the (... names.add name:= ...) configuration
that is static.