We're making a file with a number of sheets, each containing data for a particular material. the first sheet contains formulas which calculate values based on one of the material sheet. now - we would like to create a pull-down menu with a list of all materials' names (=names of the sheets). next, the chosen name should be used in the reference string and this way Excel can use data from the correct sheet. thing is I have no idea how I can put a variable name into a string. Can somebody help me?