Need help in migrate and format content from old WP theme to new (different) WP theme

Seeking for a WP expert to migrate my old site's content from its current existing theme, to a newer more effortlessly modified and modern one. I haven't selected the new theme yet as I am hoping bidders will suggest theme and framework, for example Yoothemes/Warp, etc.

Right now the site incorporates videos from my youtube channel, and has several custom pages with tabbed content, blogs, ability to choose which ones appear on homepage slider, some ad code from a separate server etc.

The site is essentially just a guide with some videos and ads. I have seen a some themes that are our there but don't know how flexible they are

I will want some small changes lie replacing myspace link/icon with youtube, customizing theme so it fits ad sizes I use and getting the code in, and very important is not losing the SE.

Desired Skills - MySQL Administration, HTML, PHP, WordPress