I am waiting for the new Sigma 18-250mm F/3.5-6.3 DC Macro. Canon and Nikon versions are available already. There are few other zooms of similar range, but this one has MACRO capability. Now, that's ALL IN ONE.

This new lens gets down to a ratio of 1:2.9, according to the specs on Sigma's website. The previous version got down to only 1:3.4. I'd consider these lenses "close focusing" than macro lenses. Most macro lenses get down to 1:1 (some down to 1:2).