Sorry I can't add any technical knowledge to this discussion, macro 35mm motion picture work is not something I've ever done. But this is a big field that has been dealt with for years, there have been many specialty macro lens assemblies made for this type of work. Have you tried the local rental houses? Also a forum like cinematography.net (CML) or cinematography.com will have discussions and members with exactly the kind of knowledge and expertise you may be looking for. Good luck!