Using a tab name in a formula

[souljive99]

Hi,

I am looking for a way to find the tab name from a drop down list and input that into a formula. For example:

Drop Down List:
Sheet 1
Sheet 2
Sheet 3
Sheet 4

And then the formula would say:

=('Sheet Selected'!A4)

Thanks!

[Domski]

Try: =INDIRECT("'"&A1&"'!A4")

Where A1 holds the drop down.

Dom