Loop Sheets with VB to copy information from all worksheets to on overview sheet

Hi Community,

thank you already now for even reading about my challenge!!

I have the following challenge:
I will have many (more than 100) sheets in my Excel file that all have the same fixed layout. Basically containing contact information like Name, Address, Phone and some additional data and notes. Each Sheetname schould be the contacts person name.
At the first sheet I would like to have an overview list that lists some of these information. JUMP should be a Hyperlink to click that brings you to the corresponding Sheet.

Overview sheet:
Name1, Phone1, Datum1, JUMP
Name2, Phone2, Datum2, JUMP
...

My first idea was of course just to do it manually
Overview sheet:
=Sheetname1!A1, =Sheetname1!A2, =Sheetname1!A3
=Sheetname2!A1, =Sheetname2!A2, =Sheetname2!A3

The problem with that solution is that the Sheetname will sometimes change and therefore all links will not function anymore. Also the number of sheets will grow over time.

I think the better solution would be to fill out the overview sheet automatically.
I think it should run this way:
- Loop all sheets
- For each sheet copy the cell A1, A2, A3 into one column at Overview Sheet
- Write JUMP in the A4 Overview Sheet and make a JUMP as a hyperlink to the current sheet in the loop (this is the biggest challenge I think!)
- Jump to next sheet
- Jump to next column

Unfortunately my VB skills don't allow me to make it happen :-(
Maybe one of you is smart enough to put that into a code? That would be really awesome!

Thank you so much for already for reading about my problem!