I've been messing with this for the last few hours, and I finally got it to export the files to look almost look the way that I like. If you run the macro 'csv_to_pdf' you will see the 3 files that are exported. The only problem is where the item numbers are located, there are extra lines with blank spaces in them for two of the orders, the order for Sue Doe looks about correct.

CSV_to_PDF_edit.xlsm