I have been tasked with updating multiple workbooks with the same information. I have created a macro to do so upon opening of an individual workbook which works well, but is there a way to modify the existing macro to loop through the other workbooks in other folders and perform the same action? I understand I would have to change the "on open function" and run it manually. The original basic macro I created is as follows;


Sub Auto_Open()
'
' Auto_Open Macro
' List Update
'

'
    ActiveWindow.DisplayWorkbookTabs = True
    Application.DisplayAlerts = False
    Sheets("Drop Down Lists").Select
        Workbooks.Open Filename:= _
        "\\C:Mac\Shared\QA_Plan\Test Folder - Do not use these files\Master Drop Down for QA PLAN Beta.xlsx"
    Range("A4:A115").Select
    Selection.Copy
    Windows("QA Plan Rev 4 (14 MARCH 13)1 with macro.xlsm").Activate
    ActiveWindow.SmallScroll Down:=-18
    Range("A4").Select
    ActiveSheet.Paste
    Windows("Master Drop Down for QA PLAN Beta.xlsx").Activate
    ActiveWindow.Close
    Sheets("Index Page").Select
    ActiveWindow.DisplayWorkbookTabs = False
    Application.DisplayAlerts = True
End Sub
Please understand I am a very new user and am learning as I go!

I appreciate any assistance or suggestion