Summary Table generated from Data Worksheets

I have a file that contains multiple worksheets (by date) with each worksheet containing a list of names. I would like to create a summary page which details all the names in alphabetical order from the data sheets and counts the number of times they appear. For example,

Sheet 1: 25-06

User
Person 1
Person 2
Person 2
Person 3
Person 4
Person 4
Person 4
Person 8
Person 8
Person 9

Sheet 2: 26-06

User
Person 1
Person 1
Person 1
Person 8
Person 9
Person A

Summary: To contain

User 25-06 26-06
Person 1 1 3
Person 2 2
Person 3 1
Person 4 3
Person 8 2 1
Person 9 1 1
Person A 1

Attached Example, Book1.xlsx

Thanks in advance for any help

Thanks newdoverman and Piet ... I've not used the INDIRECT function before :o)

Is there anyway to also generate the list of people/users. It is variable between sheets ... I could generate it manually but a formula would be great.

Thanks

I'm a VBA novice but happy to learn :o)

Thanks Piet you're a star :o)