Help on Formula - Multiple Worksheets

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?