Excel 2007 : taking values from sheet 1 to read sheet 2 and input data on sheet 3 in that order

[asshekin]

hi, I have 3 worksheets [data sheet, info sheet, quotation sheet],
question - on the data sheet, say on B5, I say "High", I want to read from info sheet the price for "High" to be placed on the quotation sheet.
[so, if I say Low on B5 on data sheet, the quotation page should reflect the price of low from the info sheet.

how do i do this?

thanks in advance.

yikes,
i still don't understand.

if i am not using VBA but normal excel, can this be done?