You can use the Indirect function to create the address. Try something like:
=indirect("='[C:\Documents and Settings\All Users\Documents\Sales order
Forms\"&Text(a1,"0000")&".xls]Info'!B$2")

where a1 has your invoice number.

Regards,
Fred

Forms]Sheet1'!$B$3
"champagne" wrote in message
...
I have a production worksheet that links to multiple invoices saved as
individual files. I'm trying to get the information to pull automatically
from these invoices, and it's not moving on to the next invoice in
sequence.
This is what the formula looks like:
='C:\Documents and Settings\All Users\Documents\Sales order
Forms\[0048.xls]Info'!B$2

I'm getting hung up on the [0048.xls} and getting it to recognize there is
a
0049, 0050, etc. to pull from. Can anyone help?