I am using Google Sheets for a Dungeons and Dragons campaign to help me track initiative order. I have in another sheet data for monsters and other creatures (like health, armor class, stats, etc) and within the initiative sheet I use dropdowns to assign tokens (for tracking locations on a map), names, and the actual initiative order number.

Since I have the stat blocks on the initiative tracker so that I am not going back and forth, instead of manually importing every stat each time I create an encounter, I would like to be able to select the creature from a dropdown list and have it automatically import the statistics I have in another sheet into the initiative tracker sheet, but after researching I can not find the appropriate way of doing it. Any help would be appreciative.

I have fooled around with the import functions but can not find anything that seems to connect to the dropdown options.