It is possible with a bit of math, I think.
The more usual ways would be skeletal mesh, or as @MostHost_LA is saying ( I think ) using the sequencer.
I must say though, the sequencer is a real pain for this kind of thing, because it’s not general at all. Skeletal would be the way.
I’m just having a think now, might come back soon with something snazzy 