Im kinda looking for a guided solution as to how I achieve replacing the client names from the Brian012 which isnt specific to a client name Briancleaning012 for example.

As each client will appear maybe more than once in the list and the sheer volume of clients names, I would like to be able to query a template list which has the client names and replace the list which comes from our databse exported to an excel spreadsheet with the names from the temlpate..

Confused - I am