I have the Skull of Corruption staff after completing the "Waking Nightmare" quest and I need to power the staff and the Wiki says all I have to do is cast the weapon on a sleeping person and it will collect their dreams and power it up more but it doesn't seem to be working unless it takes a really long time and a lot of casting to power it up. I did it 4 times to 1 person and he woke up and attacked me. Help?

It needs to be charged with soul gems as well as dreams.

Any specific kind of soul gem or just any kind?

any kind, just like any other enchanted weapon.