Help: Auto insert data from another column with single input

[humongous]

Hi guys, I'm not sure what to search so I hope it's OK to start a new topic.

Here's my problem.

I have a set of data in table, typed vertically, and I need to copy-paste them into another table which I used to calculate the data for each column.

I was wondering if there is an easier way, besides copy-paste the data, and instead i just need put a single input ( like a formula or an integer) to do it.

It will help tremendously.

Thank you.

[martindwilson]

post a workbook with what you'd have and what you'd like to achieve

[humongous]

Attached.

In that table, on sheet 4 I had to copy paste data from E5:E29 to D3:D27

It's easy to do it vertically, but I will also need to do the same using the data from sheet3 horizontally i.e E5:K5 (It would involve another calculation table but let's deal with that later).

[martindwilson]

can't you just put in sheet4 d3
=sheet3!e5 and drag down?
ps remove the word HELP from your title it will upset the mods!

[humongous]

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.

[martindwilson]

well you've got to reference the cells somehow!