Hello again everyone!

I have inherited an Excel spreadsheet that contains information in Column A cells that I'd like to search for and then cut it from the rest of the string and paste it to another cell. Here's an example spreadsheet for the sake of context:

Example.xlsx

I need to write a formula/macro/script that searches through each cell in column A for a specified term ( e.g. "expert report" or "deposition exhibit"), and that then cuts the text in the string from the preceding "(" through the next ")". The cut text would then be pasted into the same row in column D. So if I ran the macro on the above table searching for the term "expert report" the resulting table should look like this:

Example 2.xlsx

I'm familiar with programming generally, but not specifically with macros and VBA in Excel. Can anyone help me out on this?

THANK YOU!!!
Rob