Auto insert rows into worksheet from table in another worksheet

Hello,

I have the attached spreadsheet. The Log worksheet is our 'working' worksheet and it pulls data by selecting the (+) button then (in) or (out) arrow - folder is selected and any files or emails within the folder selected, will auto insert into the LOG worksheet.

I would like specific data to pull from the LOG worksheet and auto-insert into the 'Transmittal Letter' worksheet. The column headers with the data I am looking to derive, are Document Number, File Name, Rev, Document Type, Status and Date In/Out

I have tried pivot tables, which are great for summaries but with my lack of pivot knowledge it fell flat, I tried a simple formula (=+) <-- but that does not work since it is a table the data is coming from, and auto shifts down the formulas and then the links break.

I tried making the Transmittal letter into a table as well but that did not work. So I have tapped my well of knowledge and am kindly asking for any and all help if possible.

Ok... I cannot attach any files apparently. Every file type I try to attach I'm being told is not supported - if you can also tell me how to fix this...

Thank you in advance!