It may not seem logical, but if that's what you want to do as per your
description, you may as well just go ahead and do just that.

It's not the names in the VBE ... sheet1, sheet2... etc that matter,
it's the "real" names of the sheets  you see on the tabs at the bottom
of excel.

Is it possible for you to open  all of the workbooks  at the same time?
The only limitation here is memory.