I'd like to know how to extract a specific number from a cell in a table that looks something like this:

Cell A1:
Movement Disorder (12)
Parkinson's Disease (4)
Multiple Sclerosis (5)
Stroke (1)

Cell A2:
Alzheimer's Disease (2)
Multiple Sclerosis (3)
Pain (7)

Text Extraction.xlsx

For each row I want to extract the number in parentheses that follows 'Multiple Sclerosis'. I found a clunky way of doing this using MID, FIND and LEFT functions, but it took me 2 separate formulas to get what I needed. I would like to be able to achieve this in one step. The issue I'm coming up against is that I can't use "(" and ")" to identify the starting points because there are multiple instances of these, and my search term is not always preceded or followed by the same term.

I've attached the workbook I created so far with my clunky formulas. Can anyone suggest a better way to do this?