Excel 2007 :: Copy Rows To New File

I have files that have thousands of rows in them with company names. The rows contain the company name plus lots of other info. I'd like to be able to create files or sheets with the company name as the file or sheet name with the respective rows contained within it. Make sense?

For example:

Original file or sheet
Date Company Info1 Info2
Jul Sams Expense Desk
Jan Freds Expense Doughnuts
Jun Sams Deposit Return
Feb Sams Expense Food
Dec Freds Expense TV

Would become:

Sheet or File Sams
Date Company Info1 Info2
Jul Sams Expense Desk
Jun Sams Deposit Return
Feb Sams Expense Food

Sheet or File Freds
Date Company Info1 Info2
Jan Freds Expense Doughnuts
Dec Freds Expense TV