Noob Question re Looping through workbook and VLOOKUPs

[sox316]

Hi,

Typical new VBA user here - can do almost anything with formulas, can't do much in VBA if the Recorder won't do it.

I'm after some advice on the attached workbook. It is to track employee productivity. The employees are each given a log on such as ABC123.

What I'm trying to do is write some code that will search each of the sheets titled "ABC123" and "DEF456" (the employees productivity) and in column D return the number of Processed Work from the sheets called NCL and NNCL. The NCL and NNCL sheets will be updated each day. As you can see I'm using VLOOKUP to do it which I suspect is an inefficient way of coding this. My idea was that I would use VLOOKUP to search for their log on (cell A5 of the employee sheets) and then paste the formulas as values so when the NCL and NNCL sheets are updated the next day it won't mess up their data.

Can anyone point me in the right direction please?

I've found some code online which loops through the book (the real one has 70 or so sheets), but whenever I try to select the next blank cell in column D or F I get errors. You can see the remnants of mhy attempts in the attached file.

Any help would be appreciated.

Cheers.

[arlu1201]

This can be done through an easy code. But how would the macro know for which date the data is to be populated?