Macro to Summarize daily files by copying blocks from daily files.

Hello Excel Experts,

I have a humble request for some help with programming with my 'summary' file that I need to update daily from a template file. I need to copy 5 column blocks from the '05252012' file by looking up the first column in the summary file which is a part number.

The blocks to be copied are G5:G131,L5:L131,K5:K131,J5:J131,I5:I131 from the file '05252012' and they need to be pasted to the last five available columns AD to AH. Presently I am doing Vlookups for each Part number's column block from the '05252012' array.

The problem is I get this file created daily and the next day it would be '05262012', "05272012' and so forth, and I want to copy the same blocks without having to create Vlookups again for the new file, so I would like to program my summary file to copy the same blocks and append them to the end of the summary file so I can see a progression by day of the data.

I would greatly appreciate some help with this problem, thank you for looking!
Summary File.xlsxAttachment 158113