Extract just the number from a string and reference it elsewhere

[Burrgogi]

Hi on Sheet 2, I have a cell that reads as follows:
"Total DLC Count: 551 (effective count)"

I would like to be able to reference that number (total count), elsewhere within the workbook. More specifically
Sheet 4, Cell D7.

I don't want the entire contents of that string. I just need the numerical value to be displayed. Is it possible?

 

[Burrgogi]

I thought I had updated my post. I solved my own problem.

=MID('Sheet 2'!A452,19,3)