Incredibly Cumbersome Code!

Greetings again, Gurus. It's 9:00 pm on Saturday night here in good ol' Tennessee, and I'm still working. Ain't life grand?

Here's my deal. The workbook I have attached gives me the exact end results I want, but since most of the formatting was recorded, the code is incredibly long. I'm guessing one of you guys will have a field day, and laugh your **** off, reviewing this code.

My goal is that the buyer take the one master sheet they receive from the supplier, extract the appropriate information needed to two seperate sheets and format them to print neatly. The buyers will use the printed sheets to go into the purchasin program on their computers and make changes to the purchase order. The page set up is so cumbersome because the original worksheet received is never formatted the same, some of these are coming from China, and even the type of paper is set wrong.

The workbook is attached. If you guys want to take a crack at cleaning it up a little, I would appreciate it.

Have a good one!

Jerry