As Access PassThrough query STOREDPROC can execute only one SQL instruction, you cannot execute at the same time those stored procedures.

You could use a loop like this:

Sub ExecManySPs()
  Dim i As Long
  
  With CurrentDb.QueryDefs("STOREDPROC")
  
    .ReturnsRecords = False
    
    For i = 1 To 6
      .SQL = "EXEC dbo.sp_Step" & i
      .Execute
    Next
  End With

  MsgBox ("Import Complete")
End Sub

Or if you have rights to create stored prodecure, you can create an All-In-One SP, then call it.

Sub ExecManySPsAllIn1()
  With CurrentDb.QueryDefs("qrySqsUpdTmp")
  
    .ReturnsRecords = False
      
    .SQL = "CREATE PROCEDURE [dbo].[sp_StepAllIn1]" & vbCrLf _
       & " AS" & vbCrLf _
       & " BEGIN" & vbCrLf _
       & "    EXEC dbo.sp_Step1;" & vbCrLf _
       & "    EXEC dbo.sp_Step2;" & vbCrLf _
       & "    EXEC dbo.sp_Step3;" & vbCrLf _
       & "    EXEC dbo.sp_Step4;" & vbCrLf _
       & "    EXEC dbo.sp_Step5;" & vbCrLf _
       & "    EXEC dbo.sp_Step6;" & vbCrLf _
       & "END" & vbCrLf
    .Execute
  
    .SQL = "EXEC [dbo].[sp_StepAllIn1]"
    .Execute
  
  End With

  MsgBox ("Import Complete")
End Sub