Hi,

Try this formula in your first set of merged cells (i.e. A3) and copy down as required:

=INDEX(Projects!A:A,4+ROUNDDOWN(ROWS($1:1)/6,0))

Regards