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?