Merging Worksheets into a Single one

Hi there,
I am not sure if excel has a solution to this problem - but I've been surprised in the past!

We are an educational institute that is doing online marking. We send out worksheets with columns for Student ID and the Markers scores, and we are looking for the most efficient way to gather the scores onto one spreadsheet in excel.

There might be 20 questions in the test and 100 students, each question is marked independently by two Markers, each Marker might mark 4 questions. The worksheets we send out to them are thus like this:

Marker 1A-----------------------Marker 1B-----------------------Marker 2A-----------------------Marker 2B------------------------ and so on
Student ID Q1 Q2 Q3 Q4 Q5---Student ID Q1 Q2 Q3 Q4 Q5---Student ID Q6 Q7 Q8 Q9 Q10---Student ID Q6 Q7 Q8 Q9 Q10---

Once we get all the worksheets in we can use a macro to put them all into one workbook, with one worksheet from each Marker.

What we would like to end up with is this - where QxScore = the average of the two markers


--------------Marker 1A---Marker 1B-------------Marker 1A---Marker 1B-------------Marker 1A---Marker 1B--------------and so on
Student ID-------Q1---------Q1------Q1Score------Q2-----------Q2------Q2Score------Q3---------Q3----------Q3Score-- and so on

My default way of doing this is by using VLOOKUPs, which will work, but is slow, especially when we have multiple exams to process. Also, its impossible to set up a template with VLOOKUPs when using a macro because you cannot name a table array until you have something to label.

Instead I've been looking at using the Power Query Editor: could this work? And if it works, would it be possible to set up a template to automate it for non-expert users (that is, even less knowledgable than me!).

Many thanks for your help on this! Even knowing that a template is impossible would be helpful.