Help for enhance the code - Excluding Sheet While Consolidation

Hi Experts,

I have code which is doing consolidation of all spreadsheet to master sheet.

I want to exclude one sheet say “Project 2”, while consolidation “Project 2” data / or sheet require to excluding.

I am attaching code for your reference.

Illustration fill is attached for your ready reference.

Thanks in advance

Amar K

Please Login or Register  to view this content.

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

HI AB33,

Your suggestion work very well..

SIR, What coincidence which code I shared for enhancement, is also suggested by you.

Thanks A LOT Sir, For sharing valuable knowledge & guideline.

God bless you.

Thanks

Amar K