Aberdeenshire folksinger’s voice becomes soundtrack to hopeful Aberdeen fans