While copying and pasting data is simple, pulling data from one sheet to another offers significant advantages in Excel. When you pull data using formulas, the data is linked to the source.

As you can see in Figure D, Excel populates the dropdown using the list of animals on the Lists sheet — a completely different sheet, but in the same workbook. Figure D Image: Susan Harkins ...