How do you manage multi-variable data entry from web portals without constant context switching burnout?

I am dealing with a massive workflow bottleneck and need to know if anyone has found a better logistical layout or workaround for this.

The Technical Problem: I have to manually harvest front-end data points from a secure web portal and move them into a specific Excel tracker row-by-row. Because the portal requires multi-factor authentication (MFA) and sits behind a secure corporate firewall, standard automated solutions like Excel Data from Web or Power Query completely hit a brick wall. Furthermore, corporate IT security compliance strictly blocks direct database/API access or bulk CSV exports to prevent data leaks.

Data Sample Layout: For every single client entry, I am forced to copy 4 distinct, non-contiguous variables from the browser UI into the grid:

• Column A: Client Name
• Column B: Order ID
• Column C: Revenue Figure
• Column D: Tracking Number

The Logistical Bottleneck: Because they are separate fields on the web page, I am stuck in a brutal, manual loop: copy Name - alt-tab - paste to Col A - alt-tab back - copy ID - alt-tab - paste to Col B, and so on. Repeating this 4 times per row for hundreds of entries results in over 800+ mind-numbing context switches a day.

I’ve tried using native clipboard managers Win + V, but they just dump everything into a giant, flat vertical history list. They do absolutely nothing to help with the physical logistics of where that data needs to go sequentially across the columns, meaning I still lose my place trying to match the clipboard history to the target cells. Formulas like xlookup or vlookup are completely useless here because the source data isn't queryable and only exists inside the active browser session.

Short of manually color-coding cells (which adds even more clicks) or writing rigid AutoHotkey scripts with hardcoded pixel coordinates that break the second a window resizes or scales, has anyone found a fluid way to handle this? Is there a method to queue up multiple copied items and map them to columns sequentially, or have spreadsheet users just accepted the burnout of this copy-paste ping-pong game?