VBA using text from word doc to create file name. Can anyone help? Cursing isn't so far!

I have thousands of documents in this folder. The text looks like below in bold. I want the title to skip the text "Summary Plan Description" and "Effective" (but keep the date that follows), but then create a file name using the rest. There are no headers, footers, or file metadata I can use. The file name would read "ABC Corporation-Hiring Plans-January 1, 2022-Group Number:123456" Each document lists these items in a similar sequence and they all are structured the same just different details by vendor.

Now, I know I can't use comma's and some other special characters. We can remove the ":" if needed. The main goal of this is to be able to search for these documents. Right now their name isn't clear. I am getting a huge data dump of these files and need to rename them. A huge bonus point would be if we could make the above file name, but then attach the existing/previous file name in there as well in parenthesis. Something like this.... "ABC Corporation-Hiring Plans-January 1, 2022-Group Number 123456 (File 12)"

SUMMARY PLAN DESCRIPTION

ABC Corporation
Hiring Plans

Effective: January 1, 2022
Group Number: 123456

Can anyone help? I've spent a day trying to do it myself and I know there are smarter people out there kind enough to point me in a direction. Hope everyone is having a good day!

Actually, I realized I have an excel file with the file name in column A (in black). The columns in red are the ones I want to "concatenate" with some divider such as an "-" or an "/". Any thoughts on a macro that could achieve this? Assume the files are in this location

File example. Black is file name. Red are what we want to concatenate into new file name.
File Name.JPG

Archive Location (where these will be saved).
Archive Folder.JPG


I tried for 2 hours last night as I have a new puppy that wont let me sleep. Losing my mind. If anyone has any ideas you would make my week!!