Hi All,

Is it possible to do the following without code preferabley:

I want to create a cover sheet for a presentation of some figures. Depending on the option selected at the top probabley a drop down list box will determine the population of the cover sheet.

For example

Sheet1 is my cover sheet

Sheet2, Sheet3, Sheet4, Sheet5 are my data sheets

On Sheet1 you would choose from a drop down list box (A3) which data sheet to import from.

In selected cells i would use a formula similar to the following

='A3'! H4

Where A3 is actually the name of one of the data sheets.

Many thanks for all your help in advance