Index/Match with a variable Match Column

[Shortfingers]

I have a Workbook that contains a separated sheet for each day. I am trying to link this workbook with another Workbook that has a entire year of schedules on a single sheet. I start with a Template in the Daily Workbook and create a copy that becomes an individual day. I need to have the individual daily sheets link to the appropriate column in the Year Workbook. A represented formula is =IF(A7="","",INDEX('[Pyne Driver Display 2022.xlsm]Sheet1'!$A$1:$BRF$250,MATCH(F7,'[Pyne Driver Display 2022.xlsm]Sheet1'!$B:$B,0)+1,2)) . My problem is at the end of the Match portion of the formula. I need to change the $B:$B which is correct for 1/1/22, to $G:$G to be correct for 1/2/22 based on which individual day the daily sheet becomes. I have a chart that has the correct column name (B, G, L, ect) that is tied to the date. I cannot write a formula for the Template that will change the column reference of the above formula based of the date of the created daily sheet.