The Duke of Sussex, 34, arrived to cheers at Sheffield Children's Hospital where he signed a visitors' book his mum Princess Diana also wrote in 30 years ago