Auto Order

I'm sure the title doesn't help too much. Here's my small delima. I would like to take a certain set of information and paste it into an area on a sheet then in say A1 down to d1 puts them in the order that I want. If there is some kind of extremely complicated formula, that's ok, I'm up for the challenge. If I need to put up a sample sheet, please let me know.

Sample.xlsx


Here's my form. I work as an estimator and we're trying to simplify our form so there's the less work for us to deal with.

Maybe a little more of a real life example is in order. But I do think you had the formula correct as I was playing around with it.

Sample2.xlsx

Hopefully this helps! And thanks for the time you already put into it popipipo.