Look up data across multiple sheets

[Fknoll27]

Hello all I am new to this forum and have found all of my answers on here thus far, this forum is fantastic.
However I am seeking some more info, so here it goes.

I have a workbook with multiple worksheets (about 80) all with the same format.
I enter data on a new worksheet and name the tab the date the data is entered.
The data entered is a list of names associated with the managers name of which they report to.
Am I able to make a summary of all the employees who work for their manager on a summary sheet?

I have already made a VBA code to run when I add additional sheets

Sub ListSheetNames()

Range("A1").Select

Dim R As Range
Dim WS As Worksheet
Set R = ActiveCell
For Each WS In ThisWorkbook.Worksheets
R.Value = WS.Name
Set R = R(2, 1)
Next WS
End Sub

I then Change the "MySheets" range to include any additional tabs that have been created.

I was able to get a numerical value for the amount of people by using the code

=SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!K15:K29"),B5))

B5 is the name of the manager in my summary sheet.

Can I return a list of names rather than a count?