Add a third column to your master list titled RandomFilter
Enter this formula and copy down for each row you have with data:
MATCH() function checks whether each employee number in your master list appears in your list of random numbers.
IFERROR() tells Excel what to do if there is a match.
You will need to adjust the formula so that instead of B2 you enter the cell reference for the top employee number in your master list, and instead of RandomEmployeeNumbers!$A$1:$A$100 you enter the range of cells where your 100 random numbers are. Remember to use $ so the formula doesn't break when you copy down.
Then simply filter to only display rows saying Show.