Copy Entire Row of Data from One Worksheet to Another Within the Same Workbook.

Hello:

I'm wondering if there is a way to copy the entire row of data from one worksheet into another, within the same workbook, based on the criteria "Person." Here is the spreadsheet with bogus data. You'll see several column headings entitled "Heading 6", "Heading 7", etc. to show how many total columns of data there are, just in case it will be helpful for VB coding (if that's a solution).

Is there a way to have only the "Smith" rows copied and pasted into another worksheet entitled "Smith," and the "Jones" rows copied into another worksheet entitled "Jones," etc? I'm not at all knowledgeable about macros or VB programming, but maybe that is the way to go?

Many thanks in advance.
Ralph