Depending on the PSD it could be just a matter of putting the various images as backgrounds for the body, sidebars, footer, etc. If the layout has to be pixel perfect you can start running into issues however.
(CNY Web Designs
This site should be a membership site since it so full of good stuff.
Please consider donating
which gives you access to even more good stuff.