create sheets within a worksheet based on call value

Hi

I searched on this forum and could find the results for above heading. Although, my question is a little more than that.

Is it possible to have mutiple sheets created within a worksheet, based on values in a column. Now 2 or more cells may have same value within the same column, I want one sheets created if the values are repetitive. e.g if 'nolan' appears in the column 6 times, i want only one sheet created with name 'nolan'.

Also i want all the 6 Rows (which have nolan in them) data to be copied to this newly created sheet 'nolan'. Attached is a test file with data.

searched quite a lot but was unable to find and finally came across this forum where i actually wanted to ask ! :). I am not an expert in excel, just fyi.

please let me know.

AttachmentSize
test file.xlsx11.37 KB