I have a Master file which contains 5 sheets names like SC1,SC2,SC3,SC4,SC5. I have to collate all these sheets data into my working file book based on the week commencingg
I am using the below formula by taking Helper columns which gives my result. Is there any other approach?

=VSTACK(
FILTER(INDIRECT($D$3&D5),INDIRECT($D$3&E5)=$F$4),
FILTER(INDIRECT($D$3&D6),INDIRECT($D$3&E6)=$F$4),
FILTER(INDIRECT($D$3&D7),INDIRECT($D$3&E7)=$F$4),
FILTER(INDIRECT($D$3&D8),INDIRECT($D$3&E8)=$F$4),
FILTER(INDIRECT($D$3&D9),INDIRECT($D$3&E9)=$F$4))

[![Master file][1]][1]

[![Working File][2]][2]