I have a master sheet that we link the value of a cell from a summary sheet of individual workbooks. What we do now manually, is open each workbook, go to the master sheet in column L, press =, then go back to the workbook and select cell E45. Then close that workbook. Then open the next one in the folder and repeat. I have attached images of what my master sheet looks like as well as the first sheet in each individual workbook looks like. Hopefully i have explained this well enough. If not, don't hesitate to ask any extra questions. I am looking for a macro (or a simple function within excel) that will copy cell E45 from the individual workbooks and paste as a link to column L as it goes down the list. I need it to close each workbook too once it pulls the information. Thanks in advance!