I have a workbook that references the cells in another workbook. I would like to open the other workbook and then reference it in various formulas. I can open them based on their physical filename just fine. However, I would like to assign a Logical name that I can use in my formulas. For example, the workbook might be named 2010 Labor Hours or 2011 Labor Hours Plant 100, etc. depending on what workbook the operator wants to analyze. In my formulas, I would like to refer to the Workbook as a logical name of, say, Labor Hours. Any ideas? Thanks, Eddie