spreadsheet help please!!!

[aaaaaaaaaaaaaaa]

Hi there first post so hope it makes sense when i explain my problem. I have devised a workbook comprising of 2 sheets and it works ver simple. I have the idea of what i want it to do but dont know how to get it work whether i use formulae, vlookup or macro etc. I basically on sheet one have a column labelled ref number which counts 1 to 50,000. on the second sheet i have it laid out like a word document in a sense basically plain sheet with lines for text to go. i simply want a formulae or code etc so that when on sheet two the reference number is inputted it pulls the data from sheet one into the designated areas of sheet two. ie finds the row that matches the ref number and brings each field from that row and pastes them onto the corresponding lines. I have seen a sheet that this works on i just dont know how to do it i will post my spreadsheet to someone can have a look that would be great. Also if you need any help please comment as it may not sound as straight forward as i think it does. i also have a copy of the sheet that this feature works on if that any help.

Thanks in advance.

 

[aaaaaaaaaaaaaaa]

thanks for that annd it is because i am at work and have to have caps oon in other programs sisnt mean anything by it i will have a look thanks again