How do I look up one worksheet and insert in another?

[Guest]

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.

 

[Roger Govier]

Hi

Rather than extracting data to separate sheets, why not mark your header
row and
Data>Filter>Autofilter
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.