From Gabriel’s ‘Sledgehammer’ to Simon’s ‘50 Ways to Leave Your Lover’, he has helped create memorable songs for 50 years