For field macro-photography, tripods are NOT recommended.
Take a look at the scores of hand-held macro set-ups used by Hoggers in this forum (newer set-ups start on page 4):
https://www.uglyhedgehog.com/t-32754-4.html
Fabulous on download & enlarge!
In order to capture true macro (1:1 magnification), your working distance (lens front element to subject) with a 40-mm lens will be about 40-mm (1.6-inches). 40-mm lenses are mostly used for flat document recording, not field photography.
Please read a few of the permanent posts at top of page 1, of True Macro Section.