Hello world!

Using Excel 2002 I am trying to create a workbook that contains a
master worksheet of information. One column contains a sales person
name (there are only ten sales persons). I would like to have separate
worksheets within the workbook for each sales person and have them
automatically populated with the corresponding rows entered into the
master worksheet.

In other words, if I enter a row of data into the master worksheet and
the sales person column equals "Bob", then I would like that row of
data copied to the next available row in the "Bob" worksheet. Or, if
the sales person column equals "Tom", then I would like that row of
data copied to the "Tom" worksheet.

Additionally, it would be nice if the solution allowed for sorting of
the individual sales person worksheets without breaking the automatic
copy functionality.

Thanks to anyone who can help with this!!!

Jim