VBA Find matches one character at a time

I hope this is not a repeat posting. I have not been able to find anything that meets what I am trying to do.
I am trying to go through a range of cells and for each string, search through a different range one character at a time, so that I can pull up a list that shows all of the similar options. Once I see the proper value, I'd like to select it and place it nex to the originally range.
It is similar to using Find All, but it would take forever to type in the different wildcards, select the value then copy and paste to the right spot.

Is this something that can be done? Can someone point me in the right direction?

Thanks in advance.

You would do best to post a sample workbook showing your Sheet Layout and perhaps Before and After examples.

It should clearly illustrate your problem, i.e. what you consider matches, and not contain any sensitive data.

Cheers