Find data and autofill

Looking for some help on a formula if the formula is even possible. I have attached an example for reference.

I am in need of a formula that will auto fill data based on two spreadsheets having the same job number. Basically, once I add a job number to my billing spreadsheet, I want it to recognize the same number on the status document (if there is one), then auto fill a number of fields (Item, Agency Lead), so I don’t have to manually go back and do it. I know each field would need to have a formula to find that specific information but not sure if this is possible or not.

My spreadsheets are on separate tabs too but for the example I posted the items on the same page.

Any help would be appreciated.