vba code for mapped drive

Good day

I have a problem in coming up with a formula for my report I don't know this formula is possible or not.

I've attached a file for your reference on how the formula should be.
I need a formula to lookup the job number cell "B7" under the "JobStatusReport" tap, which is located on this link -
(V:\01 Administrators\Lloyd Bellingan\Kitted Jobs) and under "JobsLocation" tap is how the location looks like, where these jobs are being saved and under "SavedJob" is how the job looks like.

So this is what I need you guys assist me with, a formula to lookup a job number under "JobStatusReport" tap cell "B7" and go to the location of the job and copy cell "B9" downwards & "F9" downwards which "SavedJob" is on this location - (V:\01 Administrators\Lloyd Bellingan\Kitted Jobs) and paste the information under "JobStatusReport" cell "C10" downwards & "I10" downwards, I've highlighted them in yellow.

So basically if I enter a different job number under "JobStatusReport" "B7 the formula should pick the information of that job under the location (V:\01 Administrators\Lloyd Bellingan\Kitted Jobs)

I really hope the information I provided makes sense, and your assistance will be highly appreciated.

Thanks