![YouTube video player](https://i.ytimg.com/vi/Unue5V6GJXg/hqdefault.jpg)
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