Open And Activate Workbook Before Runing Macro

[Howardc]

I have set up the following code to open open workbooks and to activate the macro

This is just a sample of what I want to set up as I have several branches. The code vworks perfectly. However, when selecting the macro update_workbooks. I would like to first like to select/see the name of the workbook that is going to be updated by this macro so that I can which file to choose from the downloaded files

Your assistance in resolving this is most appreciated

Sub Open_Workbooks()
    ChDir ("C:\My documents")
    Application.ScreenUpdating = False
    Workbooks.Open Filename:="C:\My Documents\BR1 parts sales.xlsm"
    Workbooks.Open Filename:="C:\My Documents\Br1 service sales.xlsm"
   
    Windows("Open Parts & Service Sales account.xls").Activate
End Sub

Sub Update_Workbooks()

    Application.DisplayAlerts = False
        Windows("BR1 parts sales.xlsm").Activate
   Application.Run "'Br1 Parts Sales.xlsm'!Auto"
    ActiveWorkbook.Close
    Windows("Br1 Service sales.xlsm").Activate
    Application.Run "'BR1 service Sales.xlsm'!Auto"
    ActiveWorkbook.Close
End Sub