The Split data across multiple sheets Addin let´s you split/categorize data from a sheet across multiple new sheets. The addin is made for Excel 2007/2010.

Features
Select any single range
Select specific columns
Arrange output columns in any order
Categorize data across sheets in current workbook, new workbook or any open workbook
Add column headers to each new sheet