need vba code to split rows to closed wb shets depends company code met with sht name

Dear sir

I have set of rawdata in(Transaction Detail)sheet @ global file i want split rows data depends upon value of "company code" to closed workbook sheets where sheet name is met company code same

i want pull only 14 column from Transaction Detail sheets to correspondence sheet values metrics sheets

find the attachment there is a sheet(working) brief explain where column takes from sheet(Transaction Detail) in global file and move of concern sheet even match company code.
C:\Users\maninata\Desktop\teste\New folder\Matrics.xlsb

any experts help on this task? need full