hi all,

i have a macro button that when pressed calls for updated info to the 'summary' sheet from the other sheets in the workbook. How can I have it so that this macro will auto update maybe every 5 minutes?

here's a copy of my macro
Sub Test()

    For x = 1 To Sheets.Count
    Application.ScreenUpdating = False
        If Sheets(x).Name <> "Summary" Then
            y = Sheets(x).Range("A65536").End(xlUp).Row
            Sheets(x).Range("A" & y & ":IV" & y).Copy Destination:=Sheets("Summary").Range("A" & x)
            Else
        End If
    Next x
    

End Sub
thanks for the help =)