Hi,

there are several ways to approach this. If your sheets are called Sheet1, Sheet2, Sheet3, etc, then you could use something like this. If your formula is in, say, row 5

=INDIRECT("Sheet"&ROW()-4&"!A47")

you can copy this down and it will put the next sheet's A47 value in the next row.

Or, if your sheets have different names, you could create a list of sheet names in column A and then use something like

=INDIRECT(A1&"!A47")

so the formula evaluates to whatever text is in A1 and adds the cell reference. If A1 has the text MySheet, then it would be

=MySheet!A47

does that help?