Hey there, davs8!
I'm sorry to hear about your connectivity issues with the WD HDD!
Clicking noises could be indicating internal hardware failure on the drive, so it's best to check how it appears on another system this weekend. Meanwhile, you could try using a different SATA cable and plugging it to a different SATA port on the motherboard. If it's still not recognized by the operating system, you should consider resetting BIOS
and also check if you have the latest SATA controller & Chipset drivers for your motherboard. You should be able to do that from the mobo manufacturer's official website.
Keep me posted with the troubleshooting & Good luck!