Clear dynamic named sheet, compare cells from 2 sheets, copy all matched rows to dynamic s

Hello all. I need some help to clear a dynamically named sheet, compare cells from 2 sheets, copy all matched rows to the dynamically named sheet. I have attached the test worksheet. I can copy specifically designated cells from one sheet to another but the matching and then copying is eluding me. I have looked at many Forum examples but nothing so far has looked like it would do what I need.

Specifically, the code currently creates sheets dynamically. Once the sheet is created, I need the entire associated rows from "1_Imported" column "A" that match the cells on "ZZ_Maintenance" column "D" to be copied to the dynamically named sheet in "A5". If the sheet already exists, the used rows from "A5" down need to be cleared first, then the new rows pasted in "A5". My production spreadsheet currently has over 550 sheets so after the initial creation, creating new sheets will not occur very often, so the clearing before pasting is what will normally occur.

Thanks in advance!!
Andrew

Trying to use the following code to compare the current value of column "D" on the ZZ_Maintenance sheet to the values of column "A" on the 1_ImportedData sheet. It compares and copies but only the first instance and the specified range on the 1_ImportedData sheet. The range needs to be dynamic and the compare needs to check each row.

Please Login or Register  to view this content.

Can someone change this to check each row on 1_ImportedData and copy/paste the corresponding data, or post a better solution?

This should be comparing 2 columns on the same sheet...wsMain is my helper sheet (EDIT) and is used to associate a name to a customer number so is being used for a different part of the overall code.

Please Login or Register  to view this content.

This should be comparing column "A" on my imported data sheet (wsData)to column "D" on my helper sheet (wsMain). Every row on the data sheet that matches the current value of the "D" column on the helper sheet needs to be copied to the current "shtName".

Please Login or Register  to view this content.

I am trying to figure this out using forum code and trying differrent things so my code probably isn't very good. If there are better ways to accomplish this that would be great.

Ok...I spoke too soon. The problem is that some of the names are 3 or more words so since the code only creates the sheet with the first 2 names, any similar names after will cause the code to overwrite the original sheet. How do I modify

Please Login or Register  to view this content.

so it will replace all the spaces between all the words with "_"? (EDIT) Examples: Richard John Willams, Richard John Willams1, Richard John Willams2, Richard John Willams Jones