Your "indicative" names ,unfortunately, hide more than they reveal about what's going on. The problem is that the longer this discussion goes, and the more details we are able to coax out of you, the more clear it becomes this is not an appropriate relational database design.
You have the start of a VBA method that might lead to the desired table structure, but the problems will only be shifted into new aspects of that design. So I suspect you'll continue down that path.
Good luck, though.
