将单元格定义为要在工作簿引用中使用的变量

I am attempting to define a cell as a variable so that I can use it when calling upon a workbook. This cell changes daily and before running this macro I create a brand new workbook with this cell as the title.I am attempting to define a cell as a variable