How to use a column name in formula reference

I am using the following formula in columns across where each new column is the next month.  'XLOOKUP("*"&$A2&"*",'[Sales by Item 2025-01.xlsx]Sheet1'!$F:$F,'[Sales by Item 2025-01.xlsx]Sheet1'!$I:$...