Phil Plait wrote a nice blog on how far the Earth is from the Moon, the Sun, and the nearest star. In his blog he points to a 1.5 min. video that shows, to scale, how far the Moon really is from the Earth.