Right, sorry about the lack of info.
I have a D5200, so it would need to be a DX mount.
Also, I'd like to shoot everything from insects, to flowers, to products, to close ups of my kids eyes, etc.
Kind of a universal macro if something like that exists. Also, something that would work well in handheld.
It is very hard to shoot macro hand held. Moving the camera even 1/8th inch will put the subject out of focus. Even with a tripod in is hard, you end up repositioning the tripod 1/4 pinchbeck and forth.
But "close up" you can hand hold, that means (given your DX sensor size) taking a photo of something about 2 inches or larger
For years I used my very old Nikon 55mm f/3.5 I used it with a Nikon F2 and then with autofocus film body then with my digital SLRs. With non-pro Nikon bodies you have to take a test shot to get the exposure then look at the histogram display. The lens is short at 55mm for an FX body but long enough for a DX size frame. At one time this lens was the sharpest lens in the world and is still better then most new ones. It is also the lowest priced used lens sells for under $100. But as of late I have a 60mm f/2.8 AFd that is easier to use.
People are saying to buy a longer 105mm or even 200mm macro lens and for good reason. It allows greater camera to subject distance and room to rig some lighting. They are right BUT if yo want to hand held the camera the longer lens forces you to a faster shutter speed or to using flash. Camera shake is a bigger issue with a longer lens. This is not a problem on a tripod.
The older 60mm lens are now available used and on the DX body are "long enough
[doublepost=1460300749][/doublepost]
Hi Charlie
...
You will find nearly all macro lenses are excellent
it doesn't have to be DX either DX or FX lenses will work OK
FWIW, I have the R1C1, used it a lot but now I have an SB 700,
hardly use it, except for the really close stuff...
This is true. Older used lenses are all going to be FX and they work well.
About lighting. I used to use those big flashes back in the film days whenI was shooting ISO 100 or so. But now with digital cameras I'm using an LED ring light. I prefer the constant light as it is more "what you see in the viewfinder is what you get" and the bright light helps to focus. (Macros loose a few stops of light when you focus closely, so the light helps.) The LED lights cost a LOT less than flash.