Here are some formulas that will always have your list of missing names together without spaces.
Your short list of names is in column A starting at A2
Your long list is in column B starting at B2
In column C, put this formula in cell C2
Drag the formula down as many names as there are in column A.
In column D, put this formula in cell D2=
INDIRECT("A" & TEXT(IF(ISERROR(SMALL($C$2:$C$20,CELL("row",A2)-1)),"5000", SMALL($C$2:$C$20,CELL("row",A2)-1)),"#0"))
Drag the formula down to allow for as many unmatched names as you are likely to get, or down as many rows as there are names in column A.
Change the size of the ranges $B$2:$B$20 and $C$2:$C$20 as required. For this example I only used 20 names 19 names in the short list in column A
In cell A5000 enter =""
This cell is used to blank cells below the list of non-matching names.
You can change the cell used (formula in column D) - but it must be in column A
When this is working you can drag the column C formulas out of the way, say to column AA where they won't be seen, and drag column D formulas into column C
Your list of unmatched names will update dynamically.