I feel sure there's a way to do this, and my minimal experience with Excel will have me spinning my wheels for too long to figure it out. So I appeal to more experienced users...

I perform energy audits for a weatherization agency, and 2 digital forms (1 PDF & 1 Excel file) have to be submitted following our audit. The 2 forms overlap considerably...the PDF is a form fillable audit assessment form, and the Excel file is a work order form for the contractors who will do the remediation work. I'd like to take the data from the assessment form & to auto populate the data into the correct fields in the Excel work order form. Can anyone point me in the right direction for the most efficient way of doing this?

Thanks for any assistance...you'll also be helping the efficiency of the GA low income weatherization program!