open file specified in a Cell location

[Aeneren]

Hello All,

Anyone tell me how to have the coding below open a specified file using the file location specified in a cell.

Sub Macro2()

'          Would like to have the code Target Sheet1 C6 and use that as its Target File
    Workbooks.Open FileName:="C:\Users\Brian\Desktop\Excell test folder\1903\4-29-2012-1903-Brian.xlsm"
    Sheets("Airway Drawer").Select
    Range("E3:M8").Select
    Selection.Copy
    Windows("Inventory Pull Sample.xlsm").Activate
    Sheets("Sheet2").Select
    Range("E3").Select
    ActiveSheet.Paste

    Windows("4-29-2012-1903-Brian.xlsm").Activate
    Sheets("Portable Suction").Select
    Range("E3:M7").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("Inventory Pull Sample.xlsm").Activate
    Range("E13").Select
    ActiveSheet.Paste

 
    Windows("4-29-2012-1903-Brian.xlsm").Activate
    ActiveWorkbook.Save
    ActiveWindow.Close
End Sub

Thanks
Aeneren