MichaelH

Put this in your Page Template

<?php
$args=array(
  'post__in'=>get_option('sticky_posts'),
  'post_type' => 'post',
  'post_status' => 'publish',
  'posts_per_page' => -1,
  'caller_get_posts'=> 1
);
$my_query = null;
$my_query = new WP_Query($args);
if( $my_query->have_posts() ) {
  while ($my_query->have_posts()) : $my_query->the_post(); ?>
    <p><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></p>
    <?php
    the_content();
  endwhile;
}
wp_reset_query();  // Restore global post data stomped by the_post().
?>

You should be able to put a function in your theme’s functions.php and ‘call’ that function in your other theme template files.

Maybe you can find a plugin that helps with that:
http://www.google.com/search?q=wordpress+plugin+tag+cloud

Maybe some ideas here:
http://wordpress.org/support/topic/need-advice-on-renaming-register?replies=5

<?php
//get all terms (e.g. categories or post tags), then display all posts in each term
$taxonomy = 'category';//  e.g. post_tag, category
$param_type = 'category__in'; //  e.g. tag__in, category__in
$term_args=array(
  'orderby' => 'name',
  'order' => 'ASC'
);
$terms = get_terms($taxonomy,$term_args);
if ($terms) {
  foreach( $terms as $term ) {
    $args=array(
      "$param_type" => array($term->term_id),
      'post_type' => 'post',
      'post_status' => 'publish',
      'posts_per_page' => -1,
      'caller_get_posts'=> 1
      );
    $my_query = null;
    $my_query = new WP_Query($args);
    if( $my_query->have_posts() ) {
      echo 'List of Posts in '.$taxonomy .' '.$term->name;
      while ($my_query->have_posts()) : $my_query->the_post(); ?>
        <p><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></p>
       <?php
      endwhile;
    }
  }
}
wp_reset_query();  // Restore global post data stomped by the_post().
?>

Note see the Time Parameters in the query_posts() article.

There isn’t a way to ‘associate’ Pages to categories in the admin. If you use categories on posts WordPress will automatically give you access to a display of all the posts in a particular category if you use something like the Category Widget.

You can also create a Page and use a plugin such as http://wordpress.org/extend/plugins/list-category-posts/

Or the Pages article has the Page of Posts example where you can code it to say if this is Page X, display category Y posts.

Look at this plugin http://wordpress.org/extend/plugins/custom-post-limits/