A South Yorkshire woman wept after discovering the moving story of how her grandfather died, years before she was born, after the secret was uncovered by a chance discovery.