Bridging the gap across micro-, macro- and mega- evolutionary timescales