This is probably very simple for most of you but I need some help. I have 20 or so workbooks in a directory and would like to occasionaly create a new summary workbook/worksheet by going to each existing workbook and getting cells B2, B3 and B4 from the "Project" worksheet in each workbook file and placing it in the newly created workbook "Summary" worksheet cells C4, C5 and C6. If you could give me some rudimentary direction I think it would jumpstart me to do some other cells.

Thanks,
John