Macro to reformat data

Right now,

We are running the following Macro to reformat data but for the most part the macro only does from step 1 to step 2 on the attached sheet. I did not know if there was a way to get it more inclusive so that it can go from Raw Data to Step 2 in one step.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Here is a breakdown of what it needs to do.

1: Replace "SAMS DISTRIBUTION CENTER" with "SDC"
2: If the "PO Number" is the same, then leave the data in the first row that it appears in and delete the data in columns A:D & H:P
3: Delete Column F (description)
4: Delete Blank Rows
5: Change Column Heading "Ship to Name" to DC
6: Then run the "PO New" macro listed above.

Please advise.