derive data from masterlist to another worksheet in same workbook

[sorab]

I have a master list on one worksheet with 8 columns of data. One of
these columns (the 4th one) has a name entry. (there are only 4 names
that would be used in all)
I would like to have a macro or an excel formula to derive on separate
worksheets ( which means 4 additional sheet, named for each of the 4
named entries in masterlist, as an entry is being made on the
masterlist.
the end result would be so that I can sort be each name on a separate
worksheet.
I dont wish to use filters on the masterlist, something which I could
have used otherwise.
Any advice ?? thanks in advance. Sorab

 

[Herbert Seidenberg]

Excel 2007
Create tabs and filter from master.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/11_29_09.xlsm

 

[sorab]

Excel 2007
Create tabs and filter from master.http://c0444202.cdn.cloudfiles.rackspacecloud.com/11_29_09.xlsm

many thanks, exactly what I was looking for - I will try to edit it
now to suit my requirements, many thanks for your prompt and accurate
response.
brgds - Sorab