Count Sheets Of Same Name In All Open Workbooks

I need to develop a VBA that counts all worksheets named sheet1 within all open workbooks in addition to many other useless tasks. I have spent many hours trying to figure out how to do that. My guess is to use some sort of with statement, but my efforts have been unsuccessful.

Sub CountWKS()
Dim wb As Workbook
Dim msg As String
Dim myTotal As Long
For Each wb In Workbooks
msg = msg & vbLf & wb.Name & vbTab & wb.Sheets.Count
myTotal = myTotal + wb.Sheets.Count
Next
MsgBox "The number of worksheets in each workbook is " & msg & vbLf & Workbooks.Count & " open workbooks and " & myTotal & " total sheets"
End Sub