Macro to link cell value in multiple workbooks to one master sheet

[ctish]

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!

 

[Ron de Bruin]

Try the code example on this page

Create a summary worksheet from different workbooks (formulas with VBA)

 

[ctish]

This works perfectly if I add this step before I change the tab names. All the tab names have to be the same in order for this to work as I needed. Is there any way to tweak the code a little so that if every tab is named something different for each work book that this process would still work?