I track jobs for techs page one example. Excel 2003

JOB TECH ACCT# STAT ADDRESS
1B 603 162395-7 CP 6844 N DE CHELLY LOOP
3B 617 164655-11 CP 10700 N LA RESERVE DR # 2106
5B 603 267454-1 CP 7270 S SAND DUNE VLY D
4B 634 131976-3 CP 5702 N CAM LAGUNA
3B 609 193005-2 CP 4961 N DIAMOND PL
16B 650 267451-1 XO 9950 N CAM DEL PLATA
1B 636 206822-7 CP 7525 W SUMMER SKY DR
10B 607 120813-8 CP 3028 W WYOMING ST
2B 609 100114-2 RS$ 6430 N MONTROSE DR
3B 603 168731-9 CP 4156 N RIO CANCION # 33
3B 626 231452-8 CP 7990 E SNYDER RD 11 107
I want to take all of ie 603 info in the row and display it on his own page
without having to do it manually. My workbook contains a page for each tech
The page shown above is for the imput and may contain up to 50 unique techs
and 500 jobs there are also additional columns not shown. Each tech may do 10
or more jobs per day and each job is assigned 1b 2b 3b etc. dynamically as
the day progresses. I need to use this format so i can print each techs jobs
out individually at the end of the day. I also move this data via a pivot
table to another sheet that calculates pay for the tech pay and billing for
the company.Billing is address, account number and line item specific. jobs
are referenced by the job number which is dynamic until the end of the day
at which time it is set and can be referenced up to 3 years. I filter these
columns and could filter and copy at the end of the day pasting to their page
but that would be time consuming with 50 techs.