From a technical standpoint, the key element of that system is that it shoots wide angle from infinity to 1:1 (24 mm x 36 mm), while keeping the lens entrance pupil in exactly the same place. This prevents parallax and allows near-perfect stacking.
Inspired by Charlie's success, but daunted by the prospect of custom machining, I looked around for alternatives. One turned up rather promptly!
It turns out that the lens of my Canon A710 compact digital camera focuses entirely by moving lens elements that are behind the diaphragm. What this means, of course, is that as the lens focuses, its entrance pupil does not move at all. Perfect! And since the camera will focus down to about a 22mm field width with no attachments, it covers the same range of subject sizes as Charlie's DSLR setup.
Alas, I could not find adequate substitutes for either Charlie's subjects or his artistry, so I made do with an urban greenscape.


Canon A710 set for manual everything, 8 frames at f/8, 1/13 second, stacked with Helicon Focus.
This lens has quite a bit of barrel distortion at wide angle, and picks up even more as it focuses closer. I was concerned that I might have to correct for this before stacking, but at least for this stack, it wasn't a problem. For more extreme ranges, or more critical work, it still might be an issue.
Anyway, I know that some of you are interested in the stacked macro landscape effect, and I thought you might be interested in seeing a fairly simple way to pull it off, albeit at lower quality than Charlie's rig will do.

--Rik