Hi

Rather than extracting data to separate sheets, why not mark your header
row and
DataFilterAutofilter
Use the dropdown on name to view just the set of data for that
individual.

If required, you could copy the visible rows to another worksheet.

--
Regards

Roger Govier


"Adi" wrote in message
...
I have a workbook with 5 worksheets. The first work sheet is with "raw"
data
- date, names, and duty, etc. the other 4 sheets are meant to be for
each
name.
How do I set up the workbook/sheet, so that the 4 "name" sheets"
reflect the
"raw data" only for the individual required. I think that I need to
use the
vlook up or hlookup function, but am not sure. Any assistance would be
of
great (massive) help.