pull data from multiple sheets based on input

P

Patti

I have several worksheets that all have the same format, I would like to have
an additional worksheet that has a drop down cell listing all worksheets and
then have the data pulled from the worksheet named in the drop down cell. Is
this possible?
 
E

Elkar

You can use the INDIRECT function for this. Let's say your drop-down list is
in cell A1 of your new sheet. Use this formula in B1 to retrieve the value
in cell C1 of the worksheet identified in cell A1.

=INDIRECT(A1&"!C1")

Obviously, change the cell references to meet your needs.

HTH,
Elkar
 
D

Debra Dalgleish

If your dropdown list is in cell A2, and you want to pull the value from
cell B3 on the selected sheet, use the following formula:

=INDIRECT("'" & A2 & "'!B3")
 
E

Elkar

Ah, yes, use Debra's formula instead. Mine wouldn't work if the sheet name
contains spaces.
 
Top