Basicaly, you want to edit a seamless movie timeline and soundtrack from a compilation of sources, right? For a start you will have to get your clips ripped from the source, then make sure they are either in or converted to a format that your editing/authoring program will process.
I imagine you could cobble something together with Windows Movie Maker 2, free with XPsp2. Do a google for "video editing freeware" and similar searches and see what comes up. You may find something that suits your purposes.
You're looking for a professional package if you want a professonal result. Trial versons of Sony Vegas products are available here; http://www.sonymediasoftware.com/products/vegasfamily.asp
You may also consider Adobe's Premiere and related products here; http://www.adobe.com/products/premiere/
Programs like these are neither cheap nor easy to master though. If you are a beginner, what you want to attempt is pretty challenging. If you enjoy learning, you will have a great time though.