Why don't you give actual cell references, that will help. Instead of
saying:
Cell 1 sheet 1 = Sheet 2 Cells 1 - 4

Say:
Sheet1!A1 = Sheet2!A1:A4

Or whatever the actual cells should be. It will be easier for someone
to help you. OFFSET formulas are probably the solution for this task.