Portable external hard drive not showing up in device manager

Hi All,
I have wd external portable hard drive.

Yesterday some how my portable external hard drive started showing up like regular drive with G letter instead of its its name with assigned letter M. i was getting message like format disk . So i tried to disable and enable it from device manager. after i disable it from device manager, WD not showing up in device manager at all. I am not enable it back. I also checked in computer management window but its not showing up there too.

I see that Hard drive light stopped blinking and its steady now. It was blinking as soon as i connect it to PC.

Can anyone please suggest me how can i get my data? i need some data urgently from my hard drive.

Note: WD Hard drive is making some click click noise.