Hello guys,

in the worksheet 'Stock' have a table with many columns , and in one column
the input list has always 4 names of people. (Haris, Chris, Tom, Michael)
Now i want to have 4 different worksheet, one for each person. How can i
gather the data of each speicific person and transfer it automatically to
each person's worksheet? (For example in the 'Haris' worksheet, to search the
columns of the names in the 'Stock' worksheet and show only the ones with
Haris in them).
If i understand if this is possible, then i can do it also for the other
variables in the other columns, and create similar worksheets.

Thank you very very very much in advance,
Haris