Attach & Move Component Within Bounds

Hello,

I’m trying to attach and move a mesh component (sphere) within the bounds of another mesh component (wall). I haven’t been successful in doing this and I’m hoping to get some help. Basically, I want to move the sphere on the Z and X-axis and lock it on the Y or to the width of the wall. This movement would be in relation to the position of the player. So, as the player moves left, right, up or down, the sphere will follow the player.
I’ve made many attempts at attaching a component to component and updating location but I have not been successful. I’ve tried lerping between sockets but no luck there. Any advice in this endevour would be greatly appreciated.

Thank you,