VLookup - partial text

Hello,
I have two sheets. One a user input sheet, the second the data sheet.
I would like the user to be able to enter a five digit student reference into cell A2 on the entry sheet. This would then "lookup" and populate B2 - I2 with different pieces of information relating to that student reference.
The issue i am having is that on the data sheet the reference is actually 11 characters long with the final five making up this shortened user reference. (the first six are the same for all students)
At present we tried a =right but the formula will not produce values from the vlookup up, i believe because it is a result of a formula.
could anyone help with a formula that could work, perhaps with the first six written into it so it concatenates within the formula.
Sorry for long post.
Have attached a stripped version to try and help.