Did you try
In A1:A10 the numbers 1,2,3,4,5...10
In your cells =INDIRECT("V:\office files\Registration
Forms\[cap"&A1&"1.xls]Sheet1'!$B$22")
and copy down the row
Any reference to a file requires the file to be open

By the way 1,2,3,4 is a linear increase, not exponential.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
I have the following formula in a worksheet (MAIN):
V:\office files\Registration Forms\[cap1.xls]Sheet1'!$B$22

I want the next row, same cell (column) in MAIN to have the following
formula:
V:\office files\Registration Forms\[cap2.xls]Sheet1'!$B$22

and then on down the column increasing exponentially (cap3, cap4, cap5
etc)....where cap1 and cap2 etc are other worksheets associated with
the main worksheet.

Is there a way to do this automatically (generate the formula
automatically), rather than having to do it manually?

Any help is very much appreciated.