Once the drive isn't detected in the BIOS anymore, it's long gone. Then the only option is data recovery, or to take it to somebody with the right equipment/software to revive the drive (unbrick the drive). If the drive isn't detected in the BIOS a normal firmware flash won't work.