My WD passport spins, lights up and connects but doesnt show as an available drive
From your concise description of what happens when you plug it in, the drive mechanism has apparently been damaged - it has happened to me several times. There's not much you can do if there is physical damage. I hope you have a backup of the data on this drive!