Hopefully that points you in the right direction.
I've been meaning to do a texture tutorial for a while, so I hope that's a healthy start.
FWIW, there's usually no need to use quite as many maps as I used on the cube, so *don't* feel overwhelmed. I usually start with just a diffuse map and then only start adding more maps when something doesn't look right. Sometimes a good diffuse map and the right material settings are all you need.