Formulas – Google Sheets Query Where Cell Value

I'm looking for help editing a Google Sheets formula. I want the formula to import the range from another spreadsheet that matches the value of a specified cell. I can only equate the "where" in the formula with a hard-coded text. Can someone help?

https://docs.google.com/spreadsheets/d/1BoIre_wWE6yfiFvLseWGn3XNqK4gUS2wqdVenR32q2M/edit?usp=sharing

https://docs.google.com/spreadsheets/d/1YZtd4188cA2zG1ZeR_CisJbH6ykxjzNvmmr3LSeEXHk/edit?usp=sharing

Formula:

= QUERY (IMPORTRANGE ("https://docs.google.com/spreadsheets/d/1BoIre_wWE6yfiFvLseWGn3XNqK4gUS2wqdVenR32q2M/edit#gid=20780806", "CM! A2: G3000", "SELECT Col1, Col5" & # 39;) ")

I would like cell C1 to be referenced instead of "cross fit."