Select from Drop-down and Pull Data from Different Worksheet in Excel

Microsoft Excel Tips and Tricks

In this video I demonstrate how to extract data from a specific worksheet based on that worksheet name being selected in a drop-down list. To achieve this you need to understand the syntax used when referencing cells on another worksheet. You also need to know about the INDIRECT function.

Credit Chester Tugwell