data validation problem

hi all
i am in perfumery business. every day i am receiving all chemicals price list. plz help me to reduce my work load through excel. below are the scenario:-
I am having 1000 chemicals list ( let us call it master chemical list). and for creating particular fragrance i need to select 30 chemicals from master chemicals list.like that i need to create 200 no.s of fragrance per day. and every day master chemical list price will change.
My problem is:-
i already created dropbox data validation option for 200 no.s of fragrance now i need to find per fragrance price list. fragrance formula list are in different sheet and master chemicals price are in different sheets.
when i select particular fragrance name then it will automatically show all the chemicals name which i use to create particular fragrance.
in master chemical list every day i need to create new date in cell and below that i need to type current date price value.
i need that price list of particular fragrance to display in same page where perfumery formula are showing.
plz help it.

Thank you for the formula. I cant apply same formula for my actual excel sheet. can u plz elaborate the formula plz. some thing miss matching from my end. plz help me

Post a sample of your actual sheet.

=INDEX(INDIRECT($B$1&"!$F$1:$J$50"),MATCH(Sheet1!$A2,INDIRECT($B$1&"!$F$1:$F$50"),0),MATCH($C$1,INDIRECT($B$1&"!$F$1:$J$1"),0))

B1= Sheet Name

A2= Component

CS1=Date

INDIRECT allows use to search a variable Sheet i.e. defined by B1

First MATCH selects row for component

Second MATCH selects Date column

INDEX returns the value from matched row and column in range F1:J50

Thank you for the help.
I am not getting result in my excel sheet some thing miss matching in my formula plz correct my mistake and plz explain where I did mistake. Thank you all alotin advance.

Brother love u a lot. you solved my problem thank you very much....