Why can't I see my hard drive?
Turns out I had a hard drive failure which is why my Mac couldn't see the drive and why Disk Utility couldn't see the files on the drive.

After trying many things, I found a utility called Data Rescue 4 for Mac and it scanned the drive, found all the files and I was able to recover everything.