Macros To name Worksheets

Hi

When exporting Excel worksheets into Workbooks via macros, my new workbooks are titled sheet1, sheet2 etc
I would like my worksheets to be named based on the data displayed
For example my excel report give data by student names
It is grouped by student name hence the number of worksheet for each individual student
So the first column give student name, second student Id etc etc
Is there a way I can have my worksheet the same name as the data displayed in the first column

I'm guessing it has something to do with cell range