When you take macro photos with close focus, your depth of field is like a very thin slice of the scene, you can think of it of having a plane of just a millimeter or so deep that you are scanning through the subject, taking a frame each time. So if your subject is something like a monarch butterfly which is generally around 30mm in length of body and close to 55mm considering both wings and body, you might need to take 60-70 frames then focus stack them afterwards to get critical focus on all parts of the subject.

I'm not sure what folks use now, but Zerene Stacker ( https://zerenesystems.com/cms/stacker ) was the gold standard when I was doing serious macro photography about ten years ago.