You need to use the InStr VBA function to find the starting and ending
position of the brackets, however, brackets  are common in XML/HTML code,
and you are better off finding a unique value closest to the "<" bracket
first before moving onto breaking out the data.

Look up the use of InStr, to learn how to find the position (numeric)
location of a text  string. Then write  your code  to find the position of
the unique value mentioned above, then the starting and ending positions
of the brackets there after. Once you have these positions you can pull
the data from between them.