Unable to compare two sets of Data than pull out row of information to new sheet

[siourisc]

This is my first post, so bare with me if I need to make some adjustments. I have tried a couple different formulas and am not getting the results I would like. In a nut shell I am comparing to sets of data by employee number. If a match between the data does NOT exist I would like that entire row of information pulled to a new Sheet. I will be researching those specific individuals.

Based on my attached file, I am comparing to see if on the Master Sheet Column C "EE SS" has a matching EE SS on Today's sheet. If their is NOT a match I would like that entire row from the Master Sheet to pull into a row on Sheet 2.

I thought about doing VLookup and than if no value is generated using the Array formula function to pull that info. I also that about using an if than statement where if no match is found a number would be generated in hidden column D, at that point I would use an array formula to pull the row into my new sheet. Unfortunately I couldn't get the If/Then statement to work correctly, or the Array formula to function properly either.

Here is an example of the If statement I used:
=IF(C5='Today''s'!C2:C5,1,0)

My Array formula failed to pull over the Row that was selected as well. I would end up with just "0's" in my cells. I am aware of having to use the CTRL,SHIFT,Enter when copying over numerous columns.

Thank you in advance for all of your help.