I would like to be able to do something similar to

if c3 = 'NF' then cut row c, paste row c to sheet(tab) 2 in the same workbook

I am having a hard time finding the right type of function/formula to use for this, any help would be appreciated.

Thanks In Advance.

Michael