Yes, you can use a listbox to list your daily worksheets and use that to trigger the data copy.