Vlookup across multiple sheets backwards compatible with older versions of Excel

Hi Guys,

I have a vlookup issue which is essentially twofold.

1 - Performing a vlookup across multiple sheets
2 - I want to be able to distribute this out, so the function used needs to be compatible with older versions of excel.

If at all possible I don't want to have to use VBA in order to do this.

As always it is easier to explain the problem with an example spreadsheet so I have attached an example spreadsheet to this question.

If anyone could help I would be very grateful.

Best regards

Alan