When you link a cell in Excel to a cell from another worksheet, the cell that contains the link shows the same data as the cell from the other worksheet.

I have a relatively simple Excel task (I hope). One workbook, two sheets (Sheet1 and Sheet2) Sheet 1 has a dropdown Data Validation list that has 30 options. The user will choose an option from ...

Repeat this action with any other sheets of your Excel worksheet. You can access the various sheets (usually named "Sheet1," "Sheet2" and "Sheet3" by default) at the bottom of the workbook file.