Welcome to the forums, newcomer!
Sounds like your HDD might be dying or dead. Might want to take the drive over to a donor system and see if the HDD is detected in donor system's BIOS and then allows yuo to access the data on it. Make and model of your PSU and it's age? Mind sharing the model for your Frontech motherboard?