Attach start of cable to moving component

Hey everyone!

Sorry if this is a dumb question but for the life of me I can’t find an answer.

What I’m trying to do is create a harpoon blueprint where a grappling hook is shot out of a gun and then pulled back. I need the end of the rope to be attached to the grappling hook and start of the rope to be attached to a socket on the skeletal mesh which is playing a shooting/pulling animation.

I’ve created a cable in a blueprint, and attached the end to a moving component/actor (grappling hook). However, I can’t find any way to attach the start to a different moving actor or socket (skeletal mesh). As far as I can see I can only set a start location but not attach it to anything.

Any help would be appreciated, thanks!