Vlookup, but more complicated.

Hi,

I need to produce a spreadsheet that will do a vlookup on a table, bring back the required name, then look for this name within another spreadsheet (which could be found more than once) and then provide several cells of infomration related to the name.

I am going round in circles with this and feel way out of my depth,

Can anyone give any advice?