Excluding a sheet from consolidating sheets macro

I have a macro that I editted for my workbook to consolidate all sheets into a master sheet but now I am wondering how I can consolidate all sheets besides a specific one?

This specific sheet would be named "Data Validation" and I have 8 sheets that will take their data validation lists from this sheet so I don't need it to carry over.

I have little VBA experience so I am unsure as to the logic and order of this code and if I can even make this happen.

Please Login or Register  to view this content.

I think that worked, perfect! And I might be adding in 2 more sheets would I just do:

Please Login or Register  to view this content.