Would like some help on what formulas to use to have my payroll worksheet feed into two seperate worksheets.

Basically I have a worksheet where the header is set as one of two companies. Under this will be an incremental run number, then columns with relevant payroll data.

Example below.

Company AXB ATA ATA ATA AXB
Run 1 2 3 4 5
PayData 5555 6666 777 888 999
PayData 5555 6666 777 888 999
PayData 5555 6666 777 888 999

Basically I want one worksheet for company AXB, and one worksheet for company ATA, with data copied into each based on the company heading, so only the main worksheet with both companies is fed data. Am using excel 2003.