Index/Match with across multiple tabs

Hi there

I have received 15 respondent sheets (all with same structure) who evaluated a part number according to 4 different criteria. Hence, I have Respondent 1 who gave a score for a part number for criterion 1, criterion 2, criterion 3 and criterion 4. I now want to program a VBA that allows me to automatically populate one "merged all" sheet; showing each respondent's score per criterion per part number--> see attachment

Thanks for your help!!