Search multiple sheets, return entire rows under each sheet name

I notice the use of 'Project *' for the sheet names per my sample data, but this was meant to signify that each project has a different name, so unfortunately it won't work at this stage

Firstly, have you tested it on your uploaded sample before making the above statement...
Secondly, No it won't work if your actual file setup is different to your sample upload...as the code is written for your initial requirement...
To rectify this you need to Upload a sample file depicting actual sheet names...
In future, also, to ensure accuracy and no time wasted on code, please upload actual file setup sample and explain in detail what your requirement is...

OR

If the only sheets that need to be excluded are INDEX and Your Tasks then

Replace this line...

If ws.Name Like "Project*" Then

With ...

If ws.Name <> "INDEX" And ws.Name <> "Your Tasks" Then