Hi and welcome
just to be sure : workbooks or worksheets ?
You also have different companies in the same row, so what do you want to export.
A small data sample ( sheet no pics please) and manually mocked up results would help

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post