"Wes_A" je napisao u poruci interesnoj
...

Is there a way to reference the files within the macro no matter what the
first character may be in each case?

file/workbook is referenced in macro by its object, not by name. name is
necceccery only once, when the file/workbook is openned

try this code, while having oppened few workbooks:

----
for each wb in workbooks
msgbox wb.name
next
----