Hi, hoping someone on here is able to help me?

I have a macro which enters species level data into an excel spreadsheet. The user selects the family from a drop down list, and then each species within that family (to avoid selection of species in other families, and to make selection quicker). This species data is stored in a separate sheet with named range dynamic lists.

The problem I have is adding new species to the current lists when we observe new species. I want to have a second macro within the data entry form where users can add a new species to the list, but the list needs to be selected based on the list name (which is the family name).

How can I tell the macro to "lookup" the family name in the range of lists, and then add the new species name to the bottom of that list?

thanks all! looking forward to your answers