selecting a sheet that matches the name in a cell range

Hi,

I'm having trouble selecting a newly created sheet that matches a name from a range of names in a list. As a new name is entered, it already creates a new sheet for them but then I need it copy another sheet and paste it to the newly created sheet therefore it needs to be selected but as the names are not known, they need to be matched to select the new sheet.

I need the macro to match the name and select the appropriate sheet. I think I can do it based on a singular cell reference but the cell reference is a variable with every new sheet created.

Any help is much appreciated!