In the tracker I need to make some changes on the location of the dropdown box that is being used to extract the text and add some additional data collect based of the results of the dropdown box. Currently in sheet 2 (REPORTS), I have a dropdown box(Cell K2) I use to select a date and a VLOOKUP (Cell B2) that uses the date to locate an Event # in the DATA ENTRY tab, the Event # is used to extract the text locate in another File with the matching number. Because there will be multiple dates that are the same. I need the dropdown box moved to sheet 1 (DATA ENTRY) (Cell D1), when the date is selected, the code will change in REPORTS (Cell I2). The code will determine the Event # (Cell B2) and auto fill the text. The second part is in REPORTS, have each of the Reports below the first to extract text basis on their Event #. I could have five Events on the one page.