From your description it would appear that you are wanting to grab a subset of data from a larger population.
In which case I'd suggest you use one of the filtering methods, i.e. an Autofilter or Advanced Filter to identify the data and then copy the filtered records to wherever you want them.

This can typically be achieved with a single line of macro code.