How to change work sheet number will dragging a formula

[itsajanrs]

Hi have made a excel sheet , it only a work sheet in the first work sheet I will get main calculation of the 7 days . Each sheet is same as one only data entered will be changing
I have made like this
A1='sheet1'! K2 , and then A2='Sheet1'k7 ......like that

When I tried to drag the formula down the work sheet numbers are not changing only colum numbers are changing like k2, k3. .... like that the sheet number remain same. Is their any way to drag sheet numbers with out changing colum and row numbers I need to change work sheet names , ( the reference book) while dragging or is their any way to do it . Thanks in advance

Thanks
Sajan.rs

Sent from my SM-T311 using Tapatalk

[ChemistB]

In your example, your sheet number did not change, only the row changed (by 5)

A1 = sheet1!K2
A2 = Sheet1!K7

Maybe you can give more examples. Hard to figure out a series with only 2 numbers.

[FDibbins]

Maybe something like this?
=INDIRECT("Sheet"&ROW(A1)&"!A1")

[itsajanrs]

In front sheet
The formula for WORK SHEET 0 , A1 IS ='sheet1'! K2 , and then A2='Sheet1'k7
I need copy the formula in work sheet 0 To A2 = 'sheet2'! K2,

Sent from my SM-T311 using Tapatalk

[itsajanrs]

Work sheet 0 A3 = 'sheet3'! K2

Sent from my SM-T311 using Tapatalk

[itsajanrs]

I need the formula remain same and sheet number in the formula need to be changed

Sent from my SM-T311 using Tapatalk

[FDibbins]

OK so that doesnt tell me if it worked or not?

edit:

I need the formula remain same and sheet number in the formula need to be changed

Thats what my formula does. Did you try it?
you may obviously need to adjust cell refs to suite your data

[itsajanrs]

\1

Sent from my SM-T311 using Tapatalk

[FDibbins]

upload a workbook here, not a pic

[itsajanrs]

\1

Sent from my SM-T311 using Tapatalk

[FDibbins]

please read post # 9

[itsajanrs]

Please find the attachment

[itsajanrs]

In the attachment the first book named daily report A2 formula starts

Sent from my SM-T311 using Tapatalk

[itsajanrs]

Like that I need to create for all remain pages

Sent from my SM-T311 using Tapatalk

[itsajanrs]

i have posted the the work book in it kindly advice