When you said that you can't see the drive in the BIOS, I'm assuming you meant the drive that seems to have failed.
In order to use the 'known good' drive, you will need an install disc for Windows.
Connect the drive and then boot to the OS install disc after setting it to do so in the BIOS.
I wish I had better news, but without a valid backup of the old drive, you will not be able to restore the system without starting over.
Once you have an operating system installed, a relatively easy way to try and recover whatever data is still usable on the old drive, is to get a USB external HD enclosure. Ones made for that size HD (2.5")are very inexpensive, readily available, and easy to use.
Unfortunately, you will not be able to retrieve entire programs in this manner since they will require proper installation using a CD or downloaded installer. But you may at least be able to get individual files such as documents, graphics, video, email, etc.
Data that is not transferable by directly copying from the drive may still be able to be recovered by a company that specializes in data retrieval.
Good Luck.