Why thank u for the "useful" info as always on this forum why does everyone say just google it ? Is this not a forum to get help and suggestions? And as far as equipment its on my profile if u absolutely needed it
Since macro lenses do indeed take pictures of fine detail, no one can suggest a lens unless you mention what camwera you use and your budget.
you could actually do a web search for yourself on macro lens reviews and actually answer your own question rather than depending on the random opinion of passersby who may only have shot one lens in their life.