Is there a way to create a macro the will take what is in a cel and make a worksheet for it. And put the date base on what name is in the cell. Example

Column A
A 5 rows
B 5 Rows
C 5 rows
D 5 Rows
E 5 Rows

Worksheet names would be
worksheet A would have all A 5 rows in the worksheet
worksheet B would have all B 5 rows in the worksheet
and so on.

Thanks,

James Bosco