This is a frequently requested use for WP RSS Aggregator and one of its most powerful options.
So much so that our friends at Toolset have put together a full tutorial on how to set up a custom post type, how to use WP RSS Aggregator to import content into those post types, and how to display them on your site!
