You can paste this code into a module in a copy of the master worksheet to test. It should copy c6:c307 into a new column from the newest file.
Function MostRecentFile(fldr)
'This uses late binding, so a reference
'is not required.
'Note that there is no error coding - it
'should be added...
The most recent file in a folder can be found using the FileSystemObject:
Function MostRecentFile(fldr)
'Reference: Microsoft Scripting Runtime
Dim f As File, fl As Folder, fs As FileSystemObject
Dim fd As Date
Dim fname As String
Set fs = CreateObject("Scripting.FileSystemObject")...
