Head of Macmillan Cancer Support warns of a ‘ticking timebomb’ for society if NHS and social-care systems are unprepared