How to Use Excel's Linked Picture Tool Let's say you want to create a dynamic copy of this range of regular cells on a dashboard worksheet in your Excel workbook.

Click an Excel worksheet cell that you've linked to a drop-down list. For example, if cell E1 displays a drop-down list when you click it, click that cell to select it.

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.