How to get info from a dropdown list in an excel sheet into another sheet in the same workbook?

Hellosj47​ 

OK, when you say “the most prevalent condition" do you mean the one that appears the most in the list of conditions?

Typically when you want to “copy” data from one sheet to another you can use something like =Sheet1!A1 in Sheet2 cell A1. That means whatever is in cell A1 on Sheet1 should be in cell A1 on Sheet2.

The Dropdown will change the cell value to the chosen item from the dropdown. So you can use the same formula just make it point at the cell where the drop down is.

I hope this helps. If not, please explain more with a better examples like:

I need to copy cell xxx value to cell yyy on sheet aaa.