creating custom content comprising both static and dynamic data
Panels and Views is the way to go.  However, this question is way too broad; in fact, a book could answer it.  That book is Drupal's Building Blocks: Quickly Building Web Sites with CCK, Views, and Panels by Earl and Lynette Miles.

Also see the Views tag wiki on this site, which links to Node One's excellent screencast.