Autofilter Criteria Equals #N/A Sometimes

Hi,

I have a macro which runs through a set of 4 worksheets which are identical in format. To finish off the task I need to Autofilter Row 1 with the criteria

Selection.AutoFilter Field:=8, Criteria1:="#N/A"

Then copy the contents of A2:C2 to the end of the data in A2 to A2 on a Sheet Called Not On Cons Rep.

Could someone supply me some code that will do this for four sheets and get around the problem of what to do if there are no values that match Criteria1 i.e. of there are no #N/A's then move on to the next sheet?

I have attached an example with the final result on the Not On Cons Sheet.

Many Thanks