The much-adored musician, who wrote more than 3,000 songs, was known for huge hits including ‘9 to 5’ and ‘Jolene’