Help with Excel

I'm hoping that macros can be written and shared, so I can complete the following tasks on a weekly basis.

An Excel file will be sent containing a list of properties and the people/companies associated with the property. Each new entry will start with a diamond shape and a star rating.

1. Format the output as a list and create a separate Results Spreadsheet where the results of the search will reside. The Results Spreadsheet should have the following columns:
- Column A = Sales Company - company name
- Column B = Recorded Owner - company name
- Column C = Recorded Owner - individual name
- Column D = Recorded Owner - email address
- Column E = True Owner - company name
- Column F = True Owner - individual name
- Column G = True Owner - email address

2. In the Excel file that will be provided, the following searches need to be completed:
- Search for lines containing the phrase 'Sales Company.' Collect the company name of the Sales Company and insert them into the corresponding column of the Results Spreadsheet.
- Then proceed to search for the corresponding 'Recorded Owner' and when available collect company name, individual name and email address from the lines immediately following Recorded Owner and insert them into the corresponding column of the Results Spreadsheet.
- Then proceed to search for the corresponding 'True Owner' and when available collect company name, individual name and email address from the lines immediately following True Owner and insert them into the corresponding column of the separate spreadsheet.
- Ignore any information from lines starting with and following 'Primary Leasing Company,' 'Sublet / Assignment Company,' 'Co-Working Company', 'Property Manager,' 'Asset Manager,' 'Developer,' or 'Architect.'