Bridging the gap between mesoscopic and macroscopic models: the case of multicellular tumor spheroids