Formatting (Logic issue)

[mikera]

Having issues trying to determine the best method to automate population of a spreadsheet. I receive a file with certain data elements that I paste into the tab 'Request Data'. Typically this would be an easy process of simply setting the values in the 'Stat' tab = to the corresponding one in 'Request Data', however there are two different types of orders pickup and deliveries. Pickups are submitted in the first half of columns, Deliveries will appear in the second half a row below the pickup they tie into. If there is a pickup and delivery for one order they will have the same data in columns BW-BY.

If someone could provide direction or the solution to my problem of automating this process of moving existing data elements to my own format I would be greatly appreciative.