Honestly, I have no idea what is the best way for this, because I don't know the possibilities.
I didn't know if it is possible for the user to search by names, or to do column numbers, or to just click on the column in the source workbook. Option 1 or 3 of these would be the best, but it doesn't matter really.