Indirect for year not working

Guys, this is straighfroward, I am trying to get a dependent drop down list from the list of years I have in my excel worksheet.I have already created a named range for all the respective years. What I am trying now is to get a dependent drop down list corresponding to the years entered. I understand that named ranges does not allow for numbers solely, which is why I named it for e.g _2023 ( instead of 2023), where I added the underscore in front. Next what I did was to use a combination of indrect and substitute to remove the underscore, and fetch my list on the name manager, however the data validation returns an error, and I am not able to get a result. Here is the formula I am using. Could anyone help me out here, I do not want to use anything vba or fancy to overcome this.


At data validation, list
=INDIRECT(SUBSTITUTE($G7," _",""))

btw, G7 is the address where I key in my year number, 2023,2022, etc

Thank you.