I currently use Canon 1DmkIV and 60D camera bodies as well as an Olympus OM-D E-M1 body.
For macro photography I use a Sigma 150mm macro lens, a Canon MP-E 65mm macro lens, a Tamron 60mm macro lens, a Laowa 15mm macro lens and a Tokina 35mm macro lens. I use an Olympus 60mm macro lens with the E-M1 body.
Generally, I use the Sigma 150 for larger insects (e.g. dragonflies, butterflies) or fungi, using natural light.
I use the MP-E 65mm lens and the Tamron 60mm lens with a Canon MT-24EX macro flash gun with lots of home made diffusion (see here for more information on my flash diffusion). Since the MP-E 65mm has a minimum magnification of 1:1, any insect larger than a Bluebottle fly will struggle to fit into frame. I therefore use the 60mm lens in those situations since that lens has a maximum magnification of 1:1 yet still has the short working distance of the MP-E 65 which suits the MT-24 flashgun.
The Tokina 35mm and the Laowa 15mm macro lenses are great for showing insects in their environments and are still capable of 1:1 magnification. On occasions I also use a Tokina 10-17mm fisheye lens.
I currently use a Manfrotto 055XB and for macro I use a Manfrotto 410 Junior Geared Head, great for fine adjustments
For non-macro subjects I use a Canon 400mm f5.6 L prime lens
and virtually all of my bird and mammal images were taken with this lens.