Filling an array down 1 row at a time

[nrhamilton1981]

Hello all! 1st time poster, long time lurker. I can usually always find an answer to my question, but here im stumped...and im sure its a simple formula.

I have a workbook that has a few tabs. One tab has employee numbers for every employee in column B. On a different tab, i have a grid already in the format i need for a different system import.

On the final formatted tab, each employee has (7) rows of data (start, end, lunch times) - 1 row for each day of the week. Sun - Sat

B C D

[TABLE="width: 192"]
<colgroup><col width="64" span="2" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl69, width: 64"]Day[/TD]
[TD="class: xl69, width: 64"]Employee ID[/TD]
[TD="class: xl70, width: 64"]Date[/TD]
[/TR]
[TR]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]4908[/TD]
[TD="class: xl70"]3/26/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"]4908[/TD]
[TD="class: xl70"]3/27/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]4908[/TD]
[TD="class: xl70"]3/28/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]4[/TD]
[TD="class: xl69"]4908[/TD]
[TD="class: xl70"]3/29/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"]4908[/TD]
[TD="class: xl70"]3/30/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]6[/TD]
[TD="class: xl69"]4908[/TD]
[TD="class: xl70"]3/31/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"]4908[/TD]
[TD="class: xl70"]4/1/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"]3/26/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/27/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/28/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]4[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/29/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/30/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]6[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/31/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]4/1/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/26/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/27/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/28/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]4[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/29/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]5[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/30/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]6[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]3/31/17[/TD]
[/TR]
[TR]
[TD="class: xl69"]7[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"]4/1/17[/TD]
[/TR]
</tbody>[/TABLE]


I need to fill down the Array in column "C" down by a 1 row offset from the tab where the individual ID's are located. Currently when i am filling down, its skipping 7 rows (the amount of the array)

 

[nrhamilton1981]

Any ideas?