Is there a way to use a cell value in an open workbook to access data in a closed workbook? As an example, I have a closed workbook with multiple tabs each named for a year. In my open workbook, I would like to use the value stored in A1 (e.g. 2017) to be able to pull data out of the correct sheet in the closed workbook. I want to do this without using VBA.