what i did was put =Sheet3!E5 and drag down.
Similar to copy & paste.

but imagine if i have over 50 columns.

and dozens more table.