Exhibition shines a light on years of artistic endeavour