ind data in same sheet

[Barry]

Hi, I wonder if any one can help I have a work sheet where in A4 down to A40,
I type in a list of names, B4 to Y4 down to B40 and Y40 contains data with an
average in Z4to Z40. In AP4 down to AP 80 I have another list of names which
I need to keep in the same order.
What I would like to do is: - say AP4 Has the name John Doe in it, I would
like to look in A4 to A40 find John Doe and copy the figure in Z4 to Z40 so
if John Doe is in A5 then copy the data from Z5 and paste it into AQ4.
I would then like to make 28 copies of the sheet in the workbook.
Thank you in advance to any one who has a go at this.
Barry.

 

[Rick Rothstein]

Clarification please...

Is your list ALWAYS going to be 37 names long (Row 3 to Row 40)?

You have a list of 37 names in Column A, but a list of 77 names in Column
AP. Either you have a lot of duplicates, in which case you want to copy the
same data in Column Z to Column AQ over and over again, correct? OR, there
are names in Column AP that do not appear in Column , in which case what do
you want to do for them?

Also, do you want the 28 sheets that are added to be named in any certain
way?