Way to link to the same cell in different versions of a file

[STCrosstown]

So I have a forecast that I manage and it gets updated multiple times a month (167 versions last year) and I am trying to find a way to use a formula to pull the same cell from all the versions into one excel sheet.

So the goal would be to pull in say cell AE113 from the Output tab from all 167 versions of the model onto one worksheet.

Any help is appreciated.

 

[LazyBug]

Try this with an active empty sheet:

Option Explicit

Private Sub stct()
Dim path$, file$, i&
    Application.ScreenUpdating = False
  
    With Application.FileDialog(msoFileDialogFolderPicker)
        .Title = "Select folder": .Show
        If .SelectedItems.Count = 0 Then Exit Sub Else path = .SelectedItems(1) & "\"
    End With

    file = Dir(path & "*.xls")
    i = 1
  
    Do While file <> ""
        Cells(i, 1) = ExecuteExcel4Macro("'" & path & "[" & file & "]" & "Output'!" & Range("AE113").Address(, , xlR1C1))
        i = i + 1: file = Dir
    Loop
  
    Application.ScreenUpdating = True
End Sub