Reference to tables according to a pull down selection

Hi there,

Im trying to create a reference to a table on a separate worksheet which is dependant on the selection of the 'project' letter.

i.e. When I select project 'A' from the pull down list, I get the table of data from the ProjectA tab shown on the main worksheet.

I have attached a txt file with the main page and a jpeg as well. Each of the tabs named ProjectA, ProjectB, ProjectC etc have their own specifics values but in an identical table format. Any help would be great!

Many thanks!
Peter

if the dropdown is in cell c1

=INDIRECT("project"&C1&"!A1") to retun the value of cell A1

Regards

Dav

thats great! thanks very much for your help Dav!