Modify complex autocopy from several sheets into one

Hi guys I have attached a file. I have been trying to come up with this for a while now. Please help

I modified one row of code from:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Regards,
Antonio

Hi,

Thanks for the response, but this is not what I want.

I want the source2 and source3 to not be used in calculating the average. I want to compare
source2, source3 and average amongst each other. Thus average should only use data from sh.Name like "(*"
to be calculated.

Thanks.