Google Sheet & Excel Automation Script

I need a macro or script for my Google Sheets and Excel to automate data entry. Specifically, I want it to automatically pull bold information from a specified source into designated columns, as demonstrated in a provided video.

Ideal Skills:
- Proficient in creating macros in Excel and scripts in Google Sheets.
- Strong understanding of data entry processes.
- Able to follow visual instructions precisely.

Please note, the exact source of the bold information will be provided in the video.