So I'm running reports and then after i get the data i get it in a csv format. what i want to be able to do is automate the sorting the and filtering. so one of the things I need to be able to do is create worksheets according to the data in say column "N"  so say in column "N" it theres data that says, "earth, mars, Venus, Mercury" i want a script that will take that data and create 4 worksheets with those names. How would I do so?

Visual Basic for Applications is your best bet.