Droplist of tab names

ExcelMiner Posts 3 Registration date Wednesday November 11, 2015 Status Member Last seen April 18, 2016 - Apr 18, 2016 at 06:42 PM

I have a dropdown list of all my tabnames in a workbook. I want to create formulas that will read the selection in the drop down list and use a cell value from that named sheet.

Lets say I have my droplist in Cell D13 and I want to fill cell's D16:D33 with the values from the sheet named for cells D16:D33.