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!