How to input the row's of data into the relevant worksheet automatically?

Hi,
I am currently making a excel worksheet table showing all the info about each invoices we recieve at the office.
In the mainsheet(sheet 1), I have all the bills. Then I have created different worksheets according to the different job numbers so the same info on sheet 1 is separated by job numbers and input again by copy & paste. So that it is easier to see the breakdown on each job.

sheet 1 looks like this for example:
column A B C D
row
1. job 1- t/water - detail - £10
2. job 2 - companyA- detail - £20
3. job 1 - EDF- detail - £45
4. job 1 - BT- detail - £25
5. job 3 - transport - detail - £8

(Sorry the columns and rows don't line up on the page here!)
I have named each worksheet by the job no.s so they are called job 1, job 2, job3 .....so on.

I was wondering if there is anyway that once I put job no. in column A, the rest of the information on row 1 will be automatically input onto the worksheet called job 1. I have so many bills and seeking some kind of formula or link function to save my time copying & pasting each row.
I am sorry that I couldn't explain it in shorter sentenses but I will be grateful if someone could understand what I am after and know how to do so!

Many many thanks.

See attached workbook

Thanks very much for putting the excel worksheet that separates the jobs by numbers. It is more clear to understand what I am after.

Do you know how to separate them by using a formula or such sort?
It will be great if someone knows how to link the main sheet and other work sheets in the same excel file! and I am sorry to waste people's time on this.

I am using the workbook for my office administration. So it is not for showing to the people but it will be uploaded once it is finished onto online data-store system run by Google mails.

I just didn't want to put the real excel worksheet since it has a lot of invoices, company details and is confidential. So I will probably attach the made-up version which has exactly the same format to what I am using, because the last one I put wasn't quite like it.

I also found a thread put by another person which had the answers to what I was looking for! but I wasn't sure if it works on my worksheet by just copying and pasting the exact formula since the number of columns and the position of formulated columns were different. The thread was called: Relating date between sheets in same workbook- by honestsoul.

If you could format my worksheet to what hers was formulated it will be great!!
I will send the excel workbook shortly.

Thanks a lot for spending time to read this thread.

Best regards,
nzm

This is the excel worksheet format I am working on.

If you could see the first sheet, the column A has all the job numbers and I want to separate them into relative worksheet which has its own job numbers.
Say, I want to put job called L013 into worksheet called L013 and job L177 to the worksheet called L177 etc. So every time I put down a job number in Column A, the info on the same row will automatically inputed in the relative worksheet. Hope you get what I mean.

If you could formulate the worksheets to relate to the first sheet on the workbook so that all the information in the same row will go into the ralative worksheet, it will be great!

Many thanks for doing this. I very much appriciate it.

Best Regards,
nzm