Moving specific cells to a different sheet according to criteria

[mstom]

I'm basically trying to get specific reports from excel data. I have a table with data that has to be downloaded from the internet and I want that data to be placed in separate sheets according to specific cell qualifiers. ie if column C is Yes, I want A:B and T:V, copied to a sheet2. I can figure out how to copy full lines if a single criteria is met, and I can figure out how to copy certain cells of a single line if a single criteria is met, but I'm having a hard time with putting them both together.
The end game is I have a total of 5 cells that need to be checked for every sheet but I'm hoping when I figure it all out I can just run a sub then check again for the second criteria etc etc etc? I could get this done in access but I'm having a hard time figuring it out in excel.

 

[alansidman]

This appears to be a perfect example of what Power Query can quickly derive the answer you are looking for.