software

Hi,
I have a workbook with multiple worksheets. The first 2 worksheets are the
data source sheets; they are very similar and look something like this:

Mon Tue Wed Thu
Fri

Area 1
Emp 1
Emp 2

Area 2
Emp 3
Emp 1

etc. Approximately 15 different areas, and over 30 employees located
throughout.

What I have is a separate worksheet for each employee, and I would like them
to look at the 2 data sheets and pull the data for that employee only.

The source sheets cannot be sorted by employee - they have to stay arranged
by 'area'. Therefore, HLookup won't work.

I currently have an IF statement, a separate one for each row, which does
bring the data over correctly, but I have over 150 rows of data in the 2
source sheets, therefore over 150 rows in the separate employee sheets, but
maybe with only 5 rows of actual figures.

So then I thought I'd group the worksheets and sort on them all at once, but
Excel won't let me do that.

Please help... Is there someway I can achieve this?

Thank you!