It means being in the middle of all the action.
"Ese hombre siempre le gusta andar en la punta del grito."
It is said that he likes to walk on the tip of the scream the person who wants to be the first to know everything, mainly when it comes to gossip
