I've tried postings this same question 3 hours ago, and I have yet to see it
in the list of posts.....so I'm doing it again.

Working in Excel 2002/XP, I have one file (Tasks) with multiple worksheets
(Areas of Responsibility) with all the same column headings (Name, What,
Start, Deadline).

I want to be able to pull/extract the complete row of information from all
worksheets for a specific Deadline date, and have it show up in a new
worksheet.

Can this be done? How?

Thanks
--
Diane