We have 15 different workbooks from 15 different sources. The company I have worked for has decided that they want to add columns & formulas to each of the 15 workbooks to begin tracking data. (There is 1 page for each day of the month inside thisworksheet, and they reference the previous days, for example in the mtd column the formula is: ‘F (2)’!J7+’F (3)’!I7 (to reference the 2nd day of the month plus the third, for month to date figures)) also there is a budget line that changes with each day (for example ‘BUDGET (2)’!C3*3 is for the budgeted daily line to be X 3 days)I have done 1 and need to insert that into the other 15 with the formulas. I have tried selecting all sheets in both the source and destination sheets, but that references the source file, these need to be free standing workbooks. Is there anyway to copy & paste info from 1 workbook to another and have the formulas follow to the new workbook. I will go nuts if I have to do 31 pages worth of formulas for 15 different workbooks! help please