VBA To copy specific cells to new sheet

[jpsimmon]

I am looking to go through a large chart (A19:CC219) and paste rows with a specific criteria from one of the columns to another sheet. Anyone have a code that can do this?
The goal is to auto export info added to the 'master' sheet to sub sheets with that certain column of criteria.

Thanks for the help!

 

[HERMONES]

Might be easier to write some code that copies the whole area, then once copied, removes the rows you dont want.
That is probably how I would do it.