Copy row based on value in col A + paste in new sheet, more than one value in "A" desired

Good evening everyone,
I have spent multiple hours trying to work out a problem that seems like it should be very easy but I just can't get to work, after dozens and dozens of failed attempts I found a code posted via googling that mostly works. I have a workbook with several tabs I want it to create a new tab and then copy content onto that new tab from another tab (i.e. the old tab) based on specifc values in column A of that old page ( I have a list of ~15 things I am loooking for in column A but reduced example). My issue is that the code runs perfect right until the end of the last line than before it can change to "end sub" it gives me a " Run-time error ‘1004’
Application-defined or object-defined error" and it adds an unasked for worksheet to the workbook with an ever increasing number and errors out ?? Thanks so very much for any and all help, it's greatly appreciated!! Lili

Please Login or Register  to view this content.

I also got this to mostly work but only would work with searching for one value in column a but it was ALSO erroring out at the end and trying to a add an additional worksheet.

Please Login or Register  to view this content.