Extract text between certain characters

I have a spreadsheet containing a lot of text values (see attached). I'm trying to extract certain text from between a specific set of characters and copy the value to a unique cell (on a new sheet?). One issue is that I don't know how to extract between specific characters - some version of MID or TRIM? Another issue is that there are hundreds of these values I need contained in only 37 cells. I need each extracted to a unique cell.

Eg. I want to extract "test123" from between <li data-value= >

<li data-value="test123">


let me know if you have any questions and thank you for any help!