Consolidation of data based on search criteria

Thanks AB33, its works like a Charm in the sample but not on my actual data sheet. I have attached my data sheet, can you please have a look.

Also is it possible to check the name in B2, C2,D2, E2,.... and check for the same Sheet names and copy the data?

Data will have around 15 to 20 sheets & 52 weeks Data.

Thanks much for your help!!

Regards,
PK