Large Excel spreadsheet separated into multiple worksheets via data in 1 column

I download our credit card charges each month for 20 different people into one worksheet.  I need to separate the data into individual workbooks to be sent to my employees for itemizing.  I know ther...