VBA sheet to new workbook if specific cell populated

I have a macro built that copies a single sheet from my workbook to a new workbook and saves the new workbook in a specific location. I have built out my source file and have 3 sheets (of 6) which possibly need to be added to the new saved file.

I would like save sheet 4 (the original) sheet to a new file, then look at sheet 2 and if c2 has a specific result, move the sheet to the new file, then look at sheet 17 and if c2 has a specific result, move the sheet to the new file.

And save.

My struggle is on referencing a specific cell to call the action.