I am having a worksheet with a range of data sorted in i.e. 6 columns.
The first column is populated with entries consisted of 10 different person
names (i.e. John, Mary,€¦, Paul) in random order.

What I need is to create tables in separate worksheets (named with
corresponding person) that sort data for each person name from worksheet1

Those tables should maintain the same format as the source table in
worksheet1 and they should be automatically updated when new entry is added
to the source table.

Example:
All rows that contain person name John in the source table should be listed
in separate table in worksheet €œJohn€�. When new entries are added to the
source table in worksheet1, only rows that contain person name John should be
automatically added to the table in worksheet €œJohn€�
The same should aplied for other person names as well