I would like to be able to copy a worksheet cell reference sequential worksheets and have it fill across spreadsheets for examle Sheet 2 cell C2 would have =Sheet1!C2; Sheet 3 cell C2 would have =Sheet2!C2; Sheet 4 cell C2 would have =Sheet3!C2; and so on. Every time I try to copy this reference across workbooks it repeats =Sheet1!C2. How can I achieve this without having to go to each worksheet and changing the sheet number?

Thanks
Dianna