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?


= QUERY (IMPORTRANGE ("", "CM! A2: G3000", "SELECT Col1, Col5" & # 39;) ")

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