Hi there. One comma missing:
=OFFSET(Sheet1!$BE$1,,(ROWS($1:1)-1)*3,,)