In case you want to get data for specific company only once for specific row (e.g. to put data for Company 1 from rows 1 and 3 only once into Company 1 workbook, and data for Company 3 from row 3 into Company 3 workbook):
Add 3 columns to your source table (every one indicating a specific company workbook to read the row data into);
Into added columns, enter formulas like (an example of formula in column for Company)
The formulas return True in case Specific company is found in any of those columns.

Now you either set autofilter to True for one of those added columns, and copy data into new workbook. Then the same with 2nd and 3rd added column. Or you create append queries with filter condition for specific added column to export data into every target workbook.

In case you want a row of data exported for every case the specific company is found in 3 separate columns, you have to add 9 additional columns - every one checking for specific company in specific column. The rest is same as above - only the process is repeated 9 times instead of 3.