Jerry I am sorry to bother you, but I really am having a hard time with this and you have experiance with this. I need to copy data from multiple workbooks and paste to one. I need to create a macro that will go to multiple other spreadsheets (files) and gather certain data (from cells I27, j27, k27) and bring it back to my current spread sheet (and paste to cells c65, d65,e65). For example every day the same spreadsheet is filled out and saved by the date (11-18-10). I need to be able to create a one spreadsheet to copy data from certain cells in each of those sheets and copy them into a yearly spreadsheet with each row as a date and paste into cells c, d, e of that date row. So there is a workbook for everyday with the same format. I need to copy three cells from each of those workbooks and paste them into one workbook that each row is a day and I need to paste that data into the correct row (date).
