How to crop and pan a Flipbook sprite animation?

I have a sprite animation that I want to use as the “fill” on a round health bar. I can’t figure out how to crop and pan the animation inside the health bar though. Basically, this what I’m trying to achieve:

Here’s the setup:

I’ve searched on the forums but can’t seem to figure out how to achieve this. Any help or suggestion is appreciated. Thanks!

No suggestions ? Still stuck…