Animating Textures HELP!

Hello,

I have a brick wall texture in my game, and I want to animate it so that when it is shot with bullets, the part where the wall is shot is replaced with a bullet texture. I am not quite sure how to create this effect. Can somebody please help me out?

Thanks!

from http://www.nilunder.com/tutorials