You can try resetting your bios and have it "load optimized settings" and see if it will see the drives again. Make sure to reset any bios setting back to what it needs to be after loading optimized defaults (AHCI, memory if needed,...).
However, the drives not spinning is a bad sign. Pulling the power may have blown the motor. If your motherboard doesn't have hot swap capability, I would not pull drives while they are powered up and connected to the motherboard.