I have 20 workbooks (called '8.125' to '8.145', increasing in increments of 0.001) and a master workbook in the same file.

In cell A1 of the master workbook I have the following formula, which extracts the value in cell F4 from the workbook '8.125':

='[8.125.xlsx]Sheet1'!$F$4

Is there a macro so that in cell A2 of the master workbook, it will automatically change the workbook name in the formula to '8.126.xlsx'? i.e.

='[8.126.xlsx]Sheet1'!$F$4

and so on until cell A20 in the master workbook contains the formula:

='[8.145.xlsx]Sheet1'!$F$4

Any help would be appreciated!