Seeing as they're made by Azura, Meridia and Sheogorath?

I'm not sure where you're getting the connection between Aurorans and Azura and Sheogorath. As far as I know, Aurorans are specific to Meridia. Azura has Winged Twilights.

I thought they were Meridia's exclusively? What is your source for Sheo and Azura having anything to do with them?

http://elderscrolls.wikia.com/wiki/Auroran

I wouldn't trust anything in that Wiki. You'd be better off using http://www.imperial-library.info/ (for lore) or http://www.uesp.net/wiki/Main_Page (for gameplay info.)

I second that. I prefer the UESP Wiki since you can click hyperlinks in the text you are reading if you're curious about a word or phrase. But The Imperial Library has texts that you won't find anywhere else, like those of Michael Kirkbride.

Elderscrolls wikia is edited by mescaline addled monkeys. Half of what is there is dubious or outright fabrication, most of what is left is ripped from UESP and very little else is actually good stuff regarding things such as gameplay but lore they usually get [censored] backwards wrong.