"Domenic" <domenic22@sympatico.ca> wrote in message
news:domenic22-500627.11132020072005@msnews.microsoft.com...
> Try...
>
> A8, copied down:
>
> =INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))


Clever!