I have a workbook that is fed its information from a database regarding customer information. I would like to marco that sperates the raw data onto different sheets by name.

So Sheet 1 Column A is a customers name "J.Smith"
Sheet 2 is named "J.Smith."

I want all of J.Smith's data on the sheet with his name.

How can i acomplish this?