How to Link a table or dynamic named range to a Dropdown list in Excel

Link a dropdown list in Excel to a Table or a Named rane of data. With this method, if we add a ny data to the list, the dropdown list items will get automatically refreshed. This is very useful in case if the dropdown list needs to be updated very often and this methods saves a lot fof time.