I had trouble titling this, and I think it is better explained with examples. I am not an extremely experienced excel user, but was asked to figure this out.

Worksheet 1 (delivered by software) is formatted like this: 

```
12/17/2013
Hour                  Delivered
00.00-00.59           
Employee 1            18
Employee 2            17
Total For Hour        35
01.00-01.59           
Employee 1            18
Employee 2            17
Employee 3            12
Total For Hour        47
... etc until hours 24.00-24.59

```

The number of employees in the group per hour is different each day, so i don't think that I can just simply reference the cells.

The worksheets that I want to transfer the data from worksheet 1 to are based on date, so there is one for each day. (12/17 worksheet, 12/18 worksheet, etc...)

And this is the format of the date worksheets:

```
Employee       00.00-00.59  |   01.00-01.59  |  etc. until hours 24.00-24.59
Employee 1     18               18
Employee 2     17               17
Employee 3     12
Employee 4
Employee 5

```

So basically I need the data from worksheet 1 transferred over to the individual date worksheets. I believe, the amount of employees being different for each hour/day makes this difficult. Does anyone here have any ideas of how this can be accomplished?

Also, if there are any questions, please let me know.