How to match data patterns across multiple columns

you can use wild cards on data see here
http://www.contextures.com/xladvfilter01.html
also
3. Once this data is filtered then I would like to send this data to a new "filter results" sheet.
you canjust coppy the rows and pase
or select copy to another location this would have to be on the same sheet tho' just chose somwhere not in the range of your data then copy it to a new sheet