Transpose, transfer, VLOOKUP....need an easy solution

I have to enter payroll information into an excel spreadsheet for another company that uses this information for auditing.  The software that we use to extract our payroll information will only extract it in a specific excel format. I am trying to think of the fastest way to extract the data from our exported information, into the spreadsheet that I need to turn over to the company, without having to type in every single line. The only thing I can think of is to transpose the data, then use my VLOOKUP function to import the data into the new spreadsheet, but it's difficult to do because of the way our software pulls the employees data.  I would like it to automatically fill in their Gross Pay, FICA, Federal Income Tax, State Income Tax, Medicare, and other deductions (areas highlighted in blue on certified payroll spreadsheet). I already have it set to where it automatically enters in their hours for me by extracting their time from the "Rename and Import" tab that I created.  So, A) How can I get, if this is even the right way to go about it, the data in transpose_payroll.xlsm to transpose correctly where I can make it a list that's easy to pull from, and B) if there's an easier way to do this, how can I get the information from transpose_payroll.xlsm to XXX.Certified_Payroll-Copy.xlsx?