you can do it with a a sprite sheet as a texture, and then plug it into a sub uv node in the material editor. You can have a scalar parameter as the frame, and then change that parameter in a blueprint
If you want to change the direction, use a custom rotator