I'm not a Canon user but did a quick search. How about this one? Seems a reasonable price and you've got the range, speed, and macro all covered.
I have a Tamron 90mm macro f/2.8 but have never used it for sports.
I bet there are several out there. Remember, just because it can shoot macro, doesn't mean you have to.