I assign "names" equipment for worksheet1 COLUMN 'B' that contain

            A            B
1
2                   primary
3                   secondary
4                   tool
5                   gauge
6                   cutter
7
8
9
10
11
12
...

For worksheet2 I assign cell b2 as data validation

Allow -> list
Source = equipment
Ignore blank -> check

However, after I copy the data validation to the rest of the row, something
weird happen

From cell b3 onward, clicking on the drop-down show the last blank cell
first, instead of showing the 1st value "primary".
The next cell b4, however  doesnt have the 1st value "primary"
Cell b5 doesnt have 1st and 2nd value, and so on so forth,