Paul,
Thank you very much for your reply and sample solution, I have been able to to do this. What I have been unable to to do and your solution doesn't do, is address the problem that the next imported data sheet might have 6 questions, therefore the column selection will be incorrect for the response absolute reference. The Results sheet will return zero on all responses after the 1st three questions (which is correct for the current data sheet) but would be incorrect if the number of questions changed up or down.

This is what I am try to achieve - a results sheet that doesnt change when the number of questions changes (I have had other ideas on how to do this, but they have been upset by the common BLANK that is returned in all three response areas)

Thanks again