Pushing Updates to Multiple Excel Files That have The same Layout

VBA may help:

Sub UpdateFiles()
    Dim MyDir As String, NextFile As String
    MyDir = "C:\Path\To\Your\Files\" ' Update with your directory path
    NextFile = Dir(MyDir & "*.xlsx")
    While NextFile <> ""
        Workbooks.Open (MyDir & NextFile)
        ' Apply your updates here
        Workbooks(NextFile).Save
        Workbooks(NextFile).Close
        NextFile = Dir()
    Wend
End Sub