It simply means "Shit." It's used to describe surprise and/or opposition towards a comment and/or situation. Usually in a major way.

WOMAN: I need a huge favor.
MAN: What?
WOMAN: Will you pay my rent and bills? I'll give you something to make it worth your while.
MAN: Shee-It!!!!!!!! Your hand cares about my money more than you care about me.