Which of my lenses is best suited for macro photography? How much would a lens extension tube improve the situation? What depth of field can be expected?
Here is an easy to use calculator for these questions. Just enter the focal length of your lens, focusing distance and selected f-stop, and see what happens.
How does it work? See lens magnification and depth of field for the theory behind it.