Extract part of the information in a single cell?

Dear Forum,
Was hoping someone could tell me if the following is something that can be handled with a formula, VBA or not practical with Excel.

I have a worksheet that is an export from a 3rd party program that I want to extract information from. My initial problem is that there is a single cell with multiple 'parts' of data. And unfortunilty I can't get the 'Text to Columns' to help me out as the section that I'm looking to extract is enclosed with parentheses, but also are other sections that are not to be extracted, so using the parentheses wouldn't seem to work.

The only 'system' I can see is that the item code (which is the information I'm looking to separate), is always the last set of data enclosed within parentheses. Although it is not a set of number of spaces (depends on the item code lenght).

Please see attached file for an example of what I'm looking to do.

Feasable or SOL? Any insight or advise would be greatly appreaciated.