Excel data transfer

Hello,
I have a spreadsheet that we have weekly billing sheets on. We have a sheet on it to track our PO numbers as well. There are also a variety of COG codes we use that we need the data sorted by on each billing week sheet. How would I get the information on the PO sheet to automatically move to the appropriate billing week sheet in the appropriate COG row on that specific sheet?

Any help is much appreciated!