Auto-populate data from all sheets except one

First time using Visual Basic code and so I am not experienced in this area at all.

I have found this code that does exactly what I want it to do, which is auto-populate all worksheets in the workbook to a combined master worksheet.

I would now like to add a reference sheet for drop down menus and do not know what to add to this code so that I grab the data from all the sheets except the one reference sheet - which I have named drop down lists.


Private Sub Worksheet_Activate()
Dim Sheet As Worksheet
For Each Sheet In Me.Parent.Sheets
If Sheet.Name <> Me.Name Then
If Sheet.Cells(Rows.Count, 1).End(xlUp).Row <> 1 Then
Sheet.Range(Sheet.Cells(2, 1), Sheet.Cells(Sheet.Cells(Rows.Count, 1).End(xlUp).Row, 10)).Copy Destination:=Me.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)

End If
Else
Me.Range(Cells(2, 1), Cells(Rows.Count, 10)).Clear
End If
Next Sheet
End Sub

If I'm understanding you correctly, then changing this line:

Please Login or Register  to view this content.

...to this line:

Please Login or Register  to view this content.

...should do the trick? It should ignore sheets with the name "drop down lists".

This works perfect! Thank you very much. I added yet another sheet for pivot tables and was able to add that as well to the line.