The incredible moment happened as the Grammy Award-winning legend attended the musical, A Beautiful Noise: The Neil Diamond Musical