copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2

I have been searching to find out how to do this, and can't get my code to work, please help!! I have attached a sample file for reference.

The "copy new order" and location tabs are entered daily and new information is added, we are trying to skip the step where we enter the same information into three sheets, (location tabs, copy cal, copy new order)

The order numbers in the location tabs need to have all information filled in. the information is in two other sheets ("copy cal", "copy new order"). I need it to auto populate in the location tabs from the "copy new order" tab. I need to search PO column (C) in "copy new order" tab and fill in the data from the row for that order in the corresponding location tab. I don't want to overwrite, just need to fill the information in. I have been trying to use a combination of VLOOKUP and an IF formula, however I keep getting an error in the results. I would rather have a macro written to move the data over.

From "copy new order" tab the cell in AN copies into H in correct sheet based on po# (col C in new order tab, col A in corresponding location tab)
AW in "copy new order" goes to I in location tab , AT to K, AR to L, AS to M, AF to Q, E to R, and AO to S.

the PO#s will always start with one of the following letter sequences followed by 4 number digits.
SA=MOULTRIE
SFC=COLLINS
SFH=HAMMOND
SFL=LAUREL
SFM=MCCOMB
SFT=BRYAN
SFW=WACO
SFZ=HAZELHURST

yes, only those listed. and they must be put in the correct column in the location tab and row based on PO #

In.the location tabs (Collins, laurel,etc) the PO # will be entered by another person in my office. That should be.the determining factor as to which.row to pull information from in copy new order.

Yes that's it exactly. No worries I wasn't sure how to explain it. Or if I did a good job of explaining.

Terrific!! Thank you.

One quick question, will this run to the empty cell in each tab, or does the PO# column need to be sorted in order? For example if I have PO# listed in the following order:
1512, 1518, 1515, 1513,
Will it stop after the 1512, or at the end of the 1513?

It works exactly the way I needed it to! Thank you so much!

One last thing I just realized that its overwriting data from previous updates. is there a way to specify that if the to be filled in cells are blank fill in, and if they already have data in them to not paste in them?

PERFECT!!
Thanks again!