First major retrospective in almost 30 years brings together a 'marvellously diverse' selection of works