That's the problem!Why have you got E4 & E5? They are superfluous and confusing! It's a problem that always crops up when mixing sheet logic and code logic. In my opinion don't!

VBA code ignores E4 & E5 and changes to this (keep E2 the same as in your last screenshot)

Sub ImportActH()
    Sheets("act h").Cells.ClearContents
    Workbooks.Open Sheets("input").Range("e2") & "\act h.xml"
    Sheets("act h").Cells.Copy ThisWorkbook.Sheets("act h").Range("a1")
    ActiveWorkbook.Close 0
End Sub

Sub ImportBobH()
    Sheets("bob h").Cells.ClearContents
    Workbooks.Open Sheets("input").Range("e2") & "\bob h.xml"
    Sheets("bob h").Cells.Copy ThisWorkbook.Sheets("bob h").Range("a1")
    ActiveWorkbook.Close 0
End Sub