2. In the data validity and settings under data, select series, select the data area of Sheet2 as the source, and click OK;

3. Cell A 1 of sheet1generates a "data validity" drop-down list, and the list content is the data area of Sheet2 for selection.