Does this require VLOOKUP?

I developed an extremely helpful and useful Excel sheet thanks in large part to the help I've gotten off of this site.

In fact I've fixed about 90% of what I've wanted to fix on the project, with only one thing left (that I can see so far).

In the uploaded you'll see a tab labelled WARR JOBS. The purpose of this sheet is to keep a tally of which Techs end up taking warranty jobs as they don't get paid for them. My goal is to spread them out as evenly as possible. Previously I've always had to just cut/paste the information automatically. Then H13:H21 would just run this formula to count how many occurances I had entered manually:

=COUNTIF(C8:C481, G21)

G13:G21 are the Techs' initials.

I've recently entered this code into the cells next to that to count directly from the sheet labelled COMPLETED WORK:

=SUM(IF(('COMPLETED WORK'!$H$2:$H$5979="WARR"),IF('COMPLETED WORK'!$G$2:$G$5979=G21,1)))

This looks for the occurances of the tech's initials in G21, then counts how many warranty jobs he's completed in the sheet COMPLETED WORK.

So those I have figured out. What I'd like to do (and the reason for the thread title) is that the information in columns B - D should get posted automaticlly. This is what I'd like to have happen:

If a Warranty is completed then:
'WARR JOBS'!A = 'COMPLETED WORK'!B
'WARR JOBS'!B = 'COMPLETED WORK'!D
'WARR JOBS'!C = 'COMPLETED WORK'!G
'WARR JOBS'!D = the month/day from 'COMPLETED WORK'!I

From there I could just use the first code I posted to sum up the occurances and know it is accurate.

Thank you in advance for your help!