Middle-managers are the least confident they’ve ever been. One said they had to take several months ‘to recover from the intensity of the role’