I'm automating the process to be used once a
month or so. I coded it to use autofilter the first  time around. I
guess I can use it again now on each sheet  to separate  them out
again. For the other scenario  where the same name  appears on a few
sheets in a row  - Are there any suggestions on how to code this
efficiently? I need to combine them to one sheet.