Ok, reading about 'Focus Stacking' on your link I have a question. I hope you don't mind a question from someone with no real clue about photography.
My little 'shoot and click' digital cammera has something called 'digital macro' which holds the shutter open a loooong time before giving a very clear pic (provided the camera did not move, although it seems to cope with fractional movement becuase I don't have a tripod) at a close up distance the standard macro setting would just get fuzzyness for.
I sort of guessed it might be taking multiple shots then doing some jiggery-pokery with them. Now I read about this 'focus stacking' I wonder if I was right, or is it likely to be doing something completely different.
I should say it was not a cheapy 'shot and click', and has some very good mode settings and even a manual mode, but it comes nowhere near the DSLRs that you guys use.