Kim,
There's no need to be confused.
A macro lens offers a greater degree of magnification than a standard lens and also lets you focus at a closer range. So, even if you had a standard 17-50mm lens and a 50mm macro lens because you can focus at a closer range with the macro lens you'll be able to get your subject to appear bigger in the frame even though the focal length of the 50mm macro is the same as that of your standard lens.
If you get a macro lens with a longer focal length you'll be able to stand further back to take your shot and that has two advantages. Firstly the fact that you're stood further back might cause your subject to not be so frightened and either fly or run away. Secondly if you are stood further back there's possibly less likelihood that you'll block the light reaching your subject and you may therefore be able to use a faster shutter speed.
Popular macro lens focal lengths are 50mm, 100mm, 150mm etc...
One popular macro lens is the Tamron 90mm f2.8. I have a Canon 50mm f2.5 and a Sigma 150mm f2.8.