For shots like this would a Macro lens be the best option?
I took this one with my Nikon d40 the kit lens. i'm still a noob . but i think i'm getting a hang of the manual settings.
Side note, I tried to take shots of a friend's soccer game recently...and discovered that sports shooting is an ENTIRELY different ball game. Any tips for shooting a night game under those huge awful lights with no external flash?
You need a faster lens - and fast long lenses are really expensive.
Bump the iso up a bit too - that's why some of the newest (and most expensive) SLRs are popular - the high iso performance is great so you can freeze the motion easily with little noise.