Copying data from one worksheet to another within the same workbook

[Robert_1953]

I have two worksheets within the same workbook. One worksheet is just a summary of the other, and is used exclusively for printing. The other worksheet contains multiple formulas, but with a total, which is registered in column A in Worksheet 1. 

In worksheet 2, this data may appear in column 1, column 10, or column 20. How can If I do an equal for the first row at the top of each column, how can I make it increase the row number going down the column, so that the correct data is copied?

[#2]

I can't understand what you mean. Please attach your sample file with manually entered results, which you want to be returned by formulas.