Good Afternoon,

I have a Summary Sheet which consists of 798 rows of data. (A1:H799)
The data is divided up by Name and Date. There are 42 rows per Name which consists of Mon-Sat dates. (A2:H43, A44:H85, .....)
8 cells need to be populated for each date. (G2:G8,H2 G9:G14,H9........)

Record # Date User Admin Work Type Category Task Time Processed
1 042913 John Smith - - FH4 FI4
2 042913 John Smith - - - FH10
3 042913 John Smith - - - FH8
4 042913 John Smith - - - FH9
5 042913 John Smith - - - FH13
6 042913 John Smith - - - FH14
7 042913 John Smith - - - FH15+FH16
8 043013 John Smith - - - FH4 FI4
9 043013 John Smith - - - FH10
10 043013 John Smith - - - FH8
11 043013 John Smith - - - FH9
12 043013 John Smith - - - FH13
13 043013 John Smith - - - FH14
14 043013 John Smith - - - FH15+FH16

The above table has the cell location for those 8 points. The macro would need to be able to go into a specific directory, open up the file with
the name from the summary sheet---->

Example: John Smith.xlsb

--->Go to the tabs marked 042913 Data,043013 Data..... bring back content from those cell locations and paste them into the matching location on the
summary sheet. (G2:G8,H2)

It would then need to repeat for the other 18 names and files.

Thoughts? Any help is appreciated.

Adam