Chosing the right Lens

Hi,

I am looking for a lens for close up work. Iwant to film an insect colony (ants) I am not looking for exterem macro. the Camara I got came with the wide angle lens which i know is not ideal, but with all the different focal lenths, angle of view, apatures etc. If the a formular to work out the correct lens for a specifice user case.

For example i see the lens with focla ranges of 16mm 25mm 35mm 50mm. But they all have the same description “can be used to target specific subjects located far away”

I want a lens that will allow me to focus on the frame below (slightly closer) with a decent depth of field / clarity.

Every thing I see seems to be about Wide angle survalance or telephoto / distacnce work. Any guidence would be greatly apriciated.

Thank you