Data Fetching problem

hi excel friends..........

today i am facing a new difficulty.............

i already upload a SAMPLE sheet for ready reference

the problem is when i click on Fetch Data button which is exist in Summary Sheet, please see, the coding of Fetch Data button is given below:-

Please Login or Register  to view this content.

This coding work only when the sheet name start with "Form Master (2)", "Form Master (3)", "Form Master (4)"
now click on Fetch Data button, it will fetch all the data from sheets but in this instant case it will only fetched the data from "Form Master (3)" and "Form Master (4)"..........it did not fetch the Data from "Form Master (2)" why?????????????...........can anyone fix it

thanks in advance

It's because you are doing a partial match, rather than an exact match with

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

thankyou sir it is working.......now i am testing this code on my actual sheet

You're welcome & thanks for the feedback

thankyou so much sir it is working..........but what to do when i want it fetch the data all sheets except "Sheet1" and "Save" Sheet..............thats it

As you don't have a sheet called Sheet1, not a sheet called Save, I've no idea what you mean.

These sheets are hidden.........

I am aware the you have hidden sheets, but none of them are called Sheet1 or Save.
These are the only sheet in the book
Form Master (4)
Form Master (3)
Form Master (2)
Master
Master_Data
Summary
Master_2017-18
Form 123
FormulaCheck
Match
2017-18 Work

Sorry for late reply.................yes sir i know "Sheet1" and "Save" is not exist in this workbook.......okay then let assume Form 123 and Match sheet instead of Sheet1 and Save sheet........

Now, I want when i click on Fetch Data button.....it should fetch data from all sheets except "Form 123" and "Match" Sheet..........

and tell me further how to delete this Sample file from this FORUM...........

I don't understand what you asking, your sheets come in various different layouts & styles.
Do you really want to copy data from every single one of them bar the two sheets mentioned?

Thanks for reply.............i am only want the above said code which you will earlier correct for me.........it should not consider below mentioned sheets
Master_Data
Summary
Master_2017-18
Form 123
FormulaCheck
Match
2017-18 Work

In that case change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Please Login or Register  to view this content.

oh sorry to mention some sheets names are
"Form 12345"
"Form 22222"
"Form 54789"
like this and above code will not work on this.......

sir you did not give answer.............
{ oh sorry to mention some sheets names are
"Form 12345"
"Form 22222"
"Form 54789"
like this and please amend above code which will work if sheets name start with "Form Master" and "Form 12345" something like this......}

The easiest thing to do is to ensure that none of the sheets you want to ignore start with "Form" that way you can use

Please Login or Register  to view this content.

Otherwise you may have to hardcode sheet names into the code, which is best avoided IMO

Thankyou sir..............

You're welcome