Is it possible to get information from a specific worksheet in a closed workbook using a userform? We have a workbook that is updated daily and each worksheet is named by date (3-10-09, 3-11-09, etc..) I have another worksheet that I want to use to pull info from the closed workbook. I would like to set it up using a userform that allows me to input the worksheet name so that it then pulls from that specific worksheet. Thanks for looking, its much appreciated.