Populate Data from Summary Sheet

[Youngergirl44]

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?

 

[Don Guillett]

Sure, but WHY when you can just use data>filter>autofilter

 

[Youngergirl44]

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]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

 

[Youngergirl44]

If it helps, the workbook is going to be used to calculate interest on
security deposit payments. The "Summary" sheet contains a list of the tenants
in the building, their unit number, status, move-in date, and other general
lease information - a snapshot of the building.

The subsequent sheets are for keeping track of when a deposit was paid, the
interest rate applicable, dates on which the interest is payable, interest
accrued per period, when and how interest payments were made to the tenant,
etc.

 

[Youngergirl44]

I just sent an email with before and after examples.

Thanks!