Google Sheets - Dynamically alter range based on column heading

Hiya, I've got several parts of a formula that I need help sticking together

Context is an attendance spreadsheet

Sheet 1 is called SAM Data. This looks at data on the other sheets and comes back with dates (which are the headings on the other two sheets)
Sheet 2 is called Year to Date. This has week numbers for headings from Column E to AQ in Row 1, and % data in the rows below.
Sheet 3 is called Weekly. This has week numbers for headings from Column E to AQ in Row 1, and % data in the rows below. The headings are the same as Sheet 2.

In Sheet 1, Column E looks for when Sheet 2 first fell below 94%, and returns that header/week number
Column G needs to check for the second time that Sheet 3 falls below 94%, but after the week number returned in Column E.

I've got this formula that finds the second instance for below 94% in a row in general:
=IFERROR( IF( COUNTIF(A$1:AQ$1,"<0.94")>=2, INDEX( FILTER(COLUMN(A$1:AQ$1), A$1:AQ$1<0.94), 2 ), "" ), "" )

And this one that finds the column number for when Sheet 2 first fell below 94%
=IF(E2="", "", MATCH(E2, Weekly!$1:$1, 0))

Can these two be combined so that the start of the range in the first formula is the column number given in the second formula?

Happy to share the link if I'm allowed

Thanks!