The search boxes have a hard coded name example: L6 "*Creamer*" so using your Test1 names will not work. If you replace "*Creamer*" with $K6 and it will search for the name in that cell.

You can write a macro to fill in - but I did not understand exactly what you wanted it to look like - Change a sheet to be your example of how it should look, and maybe explain where the data comes from