CREATE TABLE table_17120964_5 (man_of_the_match VARCHAR2, opponent VARCHAR2)

Name the man of the maatch for sheffield scimitars
SELECT man_of_the_match FROM table_17120964_5 WHERE opponent = "Sheffield Scimitars"
SELECT "man_of_the_match" FROM "table_17120964_5" WHERE "Sheffield Scimitars" = "opponent"