Using Photo Merge

I'm using a laptop with windows 11.  I took a series of 9 image of the one subject - on a tripod the only change was the focus point.  The lightroom classic wouldn't stack the nine images, it seem to leave some out. ie the front of the photo was badly out of focus. 

The image was taken with a Macro lens with a F2.0

Any clues as to why this is not working.