I am trying to use Excel to prepare my materials (lists of sentences)
for a psychology experiment. I have one worksheet with 490 sentences,
each starting with a three-digit reference number. I have seven
'participant' worksheets, each with a randomised list of 70 reference
numbers. The total reference numbers in the participant worksheets
(490) match the total number of referenced sentences.

Now, hopefully without typing the 490 sentences all over again, I want
to get the appropriate sentence into the same cell as its
corresponding (randomised) reference number in each of the participant
worksheets. Could anybody please tell me how I might do that?

Thanks.

Kevin