Help with concatenation/combining cells...

Not sure if a concatenation or some other formula is neccessary.
Here is what I have:

On 'sheet1'
Column A (A3:A2000) has employee numbers
Column B (B3:B2000) has dates
Column C (C3:C3000) has different codes - this is just text

On 'sheet2'
Row 2 - Cells E2:K2 have dates in them
Column C (C3:C3000) has employee numbers
Column L (L3:L3000)- this is where I need to return the information.

Basically, I'd like to return all of the codes from sheet1 based on the dates only from cells E2:K2 and the employee number on sheet1 and sheet2 (need to match those). I'd like to somehow concatenate all of the codes into the cells in column L, which would only be text.

Pl see attached file.
If you are satisfied Mark the thread solved.

New Off Call time tracker2.xlsmNo, that doesn't work. I'll upload my document. What I need is for the cells in column L of "VI Weekly Info" to concatenate the codes found in column C of "Rolling OC Log" based on the dates found in row 2 of "VI Weekly Info" as well as to match the VRS# found in column C in "VI Weekly Info" to the VRS# found in column A of "rolling OC log".

The way that it is set up right now with the information in it, cell L4 would return the following: "LMS Training, POC Duties" since it would concatenating the text from column C on 'RollingOCLog' based on the specified date range and VRS#.

Correct. And, as long as that particular person had anything in Column C of 'RollingOCLog' during the date range of 8/12-8/18 (as specified in row 2 of 'VI Weekly Info') I would want it returned in column L, concatenated.

Pl see attached file with Macro "GetFromRollingSheet".