There's an excellent tutorial on nodequeue at http://www.drupal.org.uk/node/255 and also a write-up on merlinofchaos' site about leveraging the power of the nodequeue module.