OFFSET dragging horizontally

[c0087]

This formula works correctly, but how do I get the ROW($1:$1) to change to ROW($2:$2), ROW($3:$3), etc when dragging horizontally?

=OFFSET(SHEET2!$AF48,(ROW($1:$1))*72,0)

 

[Muhammad_Usman]

1235.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
3
4	5	2	1	0	0	0	0	0	0	0
5	6	0	4	0	0	0	0	0	0	0
6	5	5	7	0	0	0	0	0	0	0
7	6	0	4	0	0	0	0	0	0	0
8	4	5	0	0	0	0	0	0	0	0
9	7	3	6	0	0	0	0	0	0	0
10	2	9	4	0	0	0	0	0	0	0
11	6	4	4	0	0	0	0	0	0	0
12	5	2	1	0	0	0	0	0	0	0
13	1	9	8	0	0	0	0	0	0	0
14	5	2	1	0	0	0	0	0	0	0
15	0	5	1	0	0	0	0	0	0	0
16	9	0	3	0	0	0	0	0	0	0
17	6	0	4	0	0	0	0	0	0	0
18	2	0	0	0	0	0	0	0	0	0
19	6	4	4	0	0	0	0	0	0	0
20	4	5	0	0	0	0	0	0	0	0
21	0	2	5	0	0	0	0	0	0	0
22	2	9	4	0	0	0	0	0	0	0
23	5	2	1	0	0	0	0	0	0	0
24	6	9	5	0	0	0	0	0	0	0
25	2	4	4	0	0	0	0	0	0	0
26	6	2	3	0	0	0	0	0	0	0
Sheet7

Cell Formulas
Range	Formula
C4:C26	C4	=Sheet8!$D48
D4:L26	D4	=OFFSET(Sheet8!$D48,(ROW($1:$1)*(72*C$2)),0)