Looping through worksheets and vlookup

[rdev]

I have a sheet A , I have to loop through the remaining sheets and look for cell B2 in Sheet A in the range E5 to F76 of sheet B , then in sheet C , then in Sheet D etc and place the vlookup values in cells D6 , D7 , D8 , D9, D10
See link of file below

I am having difficulties in establishing the loop

looping through sheets.xlsm - Google Drive


Any help would be most welcome

Thanks