1) E1=1010 and F1=Hard Disc ( then "*" is third column ) then Drop down is from sheet 3. Pl see file.

2) There is no restriction in the number of rows in A column. Depending on data up to last row code works.

File is available in previous post.