need a lookup formula to reference worksheets without opening them.

I need to consolidate budgets for every state in the USA.

Each State budget is in a central server under one directory “S:\\Budgets\22-FL.xlsx
The two letters following the “22-##“ in the name file are for the State Abbreviation.
Florida = FL , Montana =MO and so on.

In the consolidation sheet, I would like to put a formula that looks for the Two letters in a column and then extract the information from that single state budget in the consolidation sheet column.

For example, C:5 has FL

So all formulas in column C: reference to “FL” budget “='S:\Budgets\[22-FL.xlsx]Sheet1'!$I$12

Thank you!!

Mauro

***Rather not use VB or have to open each budget sheet to accomplish this.