Changing a cell reference as a sheet is copied

Hi All,

I have a workbook and I've recorded a basic macro that creates a copy of 'worksheet 2' - thats all good but in 'worksheet 2', I am referencing a cell in another sheet, ('worksheet 1') and when I create the new sheet, I want that reference to refer to the next cell, (in the column on worksheet 1).

Eg.
SHEET2 C1=SHEET1 C1

Then after the macro, I want:

SHEET3 C1=SHEET1 C2
(Sheet3 being the sheet created by the macro)

Anyones assistance would be sincerely appreciated.
TIA
KylieilyK