Hello everyone,

I am trying to create a dynamic master workbook that references data from separate workbooks that are exported daily. These daily files all have the same file name and automatically overwrite each other, and are located within the same directory. The macro I currently have will run and pull the data from the first cell, but it will not auto fill to the end of the reference list. I am guessing it's a simple solution, but after a couple days I cannot figure it out. Here is what I have so far:

'References subcription exports
        ActiveCell.FormulaR1C1 = _
        "='H:\User\daily_export_dir\\[Master Reference.xlsx]Master Reference'!R[-1]C"
    Range("A2").Select
    Selection.AutoFill Destination:=Range("A:A")
    Range("A2:A").Select
    Range("A2").Select
Any help would be greatly appreciated.