To increment the sheet numbers 1 to 30 you must use INDIRECT function

example....

=IF(INDIRECT("[Book6.xls]" & ROW(1:1) & "!D1")<"","yes","no")

Copied down to row 30


Gord

On Thu, 28 Jun 2012 17:33:30 +0000, G_off
wrote:

Garry,

I need the Rows to remain the same
I have a master spreadsheet. - each line refers to another spreadsheet
('[Power Forward 2013.xlsx]. I am good thus far. the problem is the
following number 1' - the 1' refers to a tab in the power forward 2013
spreadsheet. I have 30 tabs labeled 1 2 3 4 5..... exact replicas of
one another. what I would like to do is make that 1' automatically
change to 2' 3 4 5.
any thoughts?