Excel data transfer

Bridget2589 Posts 1 Registration date Friday January 12, 2018 Status Member Last seen January 12, 2018 - Updated on Jan 12, 2018 at 12:08 PM
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!