This looks like a really good talk on Macro Photography. It's a lecture at B&H Photo.
This is Focus Stacking. Compare the depth of field in the two images. The picture to the right is in focus from front to back. The picture below has a shallow depth of field and only the foreground is in focus.