you could just use


=sheet1![cell reference] starting at the point you want to use the relevant info.


or vlookup would work.....