Help with VLOOKUP "I Think"

Hi Guys.
Ok, here what I want this workbook to do, I have a workbook that is used in manufacturing, which has rolls 1 to 10, once the rolls are complete we need to print a label to say what roll lenths, faults etc are on the roll, so basiclly what i want the workbook to do is, if roll #1 then look at a cell to find the roll length and defects, if the roll is #2 same again down to roll #10, it might be simpler to look at the atatchment.
The prepreg tab needs to take information form the 24" runsheet tab.