Repeat a formula 5 times before changing cell reference

modifying the formula above to look at sheet one for the list without duplicates worked. Thanks so much for your help. Awesome.

=IFERROR(INDEX(Sheet1!$O$4:$O$80,CEILING(ROWS(C$2:C2)/5,1)),"")