I have two books called 1234.xls and 1235.xls
In a new workbook, in A1 I enter 1234
In B1 I use the formula =[1234.xls]Sheet2!$B$1
This returns the value from B1 of Sheet1 in the file 1234.xls
I can replace the formula by =INDIRECT("["&A1&".xls]Sheet2!$B$1") and get
the same result
If I type 1235 in A1, I get the value from the other workbook
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"djames2007" wrote in message
...
This may be confusing but we have a detail workbook for each job
(3107,3108,
3109, ...) each detail workbook has cells tied to the master workbook (the
3108 is the sheet name in the master workbook). When I start a new job I
use
the workbook from the last job and resave it as the new job I have the job
(3107,3108,3109,...) entered in cell a1 how can I use the value of cell a1
in
place of the 3108 in my formula(s) so I only change it in cell a1 (one
time)
Any help would be appreciated it would be a big time saver for me