Dynamically create sheets with similar names and copy cells on row based on matched cus#

Hello all. At the title indicates, I need help with 2 parts of my project. The first is that I have some customers that have similar names and the current code cannot validate and create additional sheets after the first one has been created. For example: Richard_John_Worthington and Richard_John_Worthington1. The code will create the first one correctly and populate it with the correct data but when the second one is processed in the code, it throws a Type Mismatch while checking to see if the name already exists.


My second problem is I need to match the customer number on ZZ_Maintenance to the one currently being processed on 1_ImportedData, then cells in column D to F on ZZ_Maintenance for the matched customer number need to be pasted on the new customer sheet in D3. The examples I have seen copy the entire row but I could not find any that would do a range of cells in the row. I am using conditional formatting in customer rows D2 to F2 to compare to the values in D2 to F3 but each customer may have their own values for the items so I can't do this manually for each new customer. I think I did the conditional formatting correctly to check the values for the entire row, but if somebody could verify that would be great!

Thanks,
Andrew