Here is my code I am simply trying to copy data from worksheets whose page name must initially be looked up (VLOOKUP).
I have a total of 42 dropdown boxes that link to sheet names that are to be added to the list.
I am fairly new to VBA and I can only get the last .copy to work.
below is my...