No shit
sherlock is used to insult someone who is stating to blatant obvious. similar to "you don't say" or "thanks
captain obvious!"
if someone is saying
something obvious instead of saying "no fucking shit" you would add "sherlock" to it just to insult them further.