Auto fill the rows after a particular selection from Drop down list

Here is one way without using VBA.

First, on a sheet create the category lists (e.g. Cool_Drinks, Ice_Cream, etc.) in separate columns.
Next create named ranges for these lists.

Example:
Name = Cool_Drinks
Refers to: Sheet2!$A$1:$A$25 (obviously, adjust ranges as needed)

Name = Ice_Cream
Refers To: Sheet2!$B$1:$B$25

On Sheet1, cell A1 create a Data Validation drop down list containing these list items: Cool_Drinks, Ice_Cream

Now, in cell B1 use this formula, copied down the column: =IFERROR(INDEX(INDIRECT($A$1),ROW()),"")

Great! Glad you were able to get it working.