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?