Excel 2003 Referencing multiple workbooks via single variable
 

I'd like to create a form that will reference an multiple existing workbook
in a folder located via a single variable. In other words if someone opens
this form and types in the job number the equations will fill the form out.
The workbooks would be located in folders on the server separated by job
number.