You can use any material you want to make sheets. Some material will last longer, or resist staining better.. but in the end, they all will work.
I'd stay away from the spandex, or any plasticy materials, but otherwise it should be fine.
100% cotton, and flannel in particular is very nice for baby sheets and blankies.