Extension tubes are a clear (no glass) tube that is fitted between a camera and lens. The result is that the lens reduces both its maximum and minimum focusing distance. This renders the lens incapable of focusing further away (distance varies depending on the focal length and the amount of extension tube added; but can be to several feet down to millimeters).
The reduction in minimum focusing distance lets the lens move and focus closer to a subject and is thus the prime intent of most uses of extension tubes as it allows an increased close up magnification. It's a cheap way to getting to macro photography.
Note tubes come in two basic types, those with and those without metal contacts. The lack of contacts makes the tubes ultra cheap, but means that you've no control over the lens AF (not a problem as most macro is done in manual focusing) and lens aperture (big problem as using a smaller aperture than wide open is often needed for macro due to the small depths of field).