I have an Excel file with about 20 worksheets in it. Two of the worksheets are named first and last. What I want to do is pull all of the workbook names between first and last into a drop down box. I know this has to be a simple For Loop but I am struggling with pulling the names without activating any of the sheets. Please help!!