The Great Cosmic Distance Debate: Mapping the Distance to Andromeda and Beyond