Maybe
Formula: copy to clipboard
=INDEX(Sheet1!$A$1:$Z$100,ROW(),COLUMN())


Drag across and down.

Regards, TMS