Autofill Increment Sheets

Vote count:

0

I have several sheets in my excel workbook labeled- P1,P2,P3 etc till P30

On another sheet I want to reference cell D11,D17,D28 (and many many more) of all these individual sheets in each row.

for eg.

Row 1: ='P1'$D$11, ='P2'!$D$11,  ='P3'!$D$11, ...... , ='P30'!$D$11
Row 2: ='P1'$D$17, ='P2'!$D$17,  ='P3'!$D$17, ...... , ='P30'!$D$17
Row 3: ='P1'$D$28, ='P2'!$D$28,  ='P3'!$D$28, ...... , ='P30'!$D$28

...

Can you please help me in making this process easier than to manually type in the sheet name each time? I am not able to use the Indirect function:

=INDIRECT("P1"&ROW()&"$D$11")

Thank you.

asked 1 min ago

Sameer_Suresh

3