I'm not using the subsequent sheets to view just one person at a time -
they're used for different calculations specific to each person.

The only thing that's the same about each of the 100+ sheets is the name and
date, which I would like to look up from the "Summary" sheet.



"Don Guillett" wrote:

Sure, but WHY when you can just use datafilterautofilter


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Youngergirl44" wrote in message
...
I want to use a sheet titled "Summary" to populate data in 100+ existing
worksheets within the same workbook. "Summary" contains a list of names
and
dates.

I want the first sheet after "Summary" to pull the first name and date
from
the list, the second sheet to pull the second name and date, and so on -
like
this:

Sheet titled "Person 1"
cell A1 =Summary!$B3
cell E1 =Summary!$A3

Sheet titled "Person 2"
cell A1 =Summary!$B4
cell E1 =Summary!$A4

Sheet titled "Person 3"
cell A1 =Summary!$B5
cell E1 =Summary!$A5


Is there a way to copy the formula across all 100+ sheets, changing the
row
referenced on the "Summary" sheet?