Creating a summary page

Hi there,

I am new to this forum, have been lurking for a while trying to find help for what I'm trying to achieve - just can't quite find exactly what I need so would really appreciate any help please.

I have a workbook with multiple spreadsheets, I need to create a dynamic summary sheet that automatically lists the name of each worksheet (with a hyperlink) , plus the dates from cells U6 and Z6 in each worksheet. The workbook will continually grow with additional worksheets being added and this is where I am having the problem - referencing the names of worksheets as yet unknown?

I also need the summary sheet to exclude the index and fees worksheets.

Cheers
Zigi

Hi zigi

I can do a lot better than this.

BRB

Try this workbook

Instructions in IndexSheet

Wow, thanks everyone. You make this stuff look so easy

Haven't tried the suggestions yet, but will get to it later today. Thanks again, much appreciated!

Hi there, I tried this one (because it looked less complicated lol!) but it hasn't quite worked. Yes, the workbook thinks there are hyperlinks there but that formula isn't returning any values?

On a new sheet, 1st, click the Formula Tab, then select Name Manager/New, and copy this in "refers to"...
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
Then in say, A2, copy this down to a few rows more thanthe amount of sheets you have (you can always copy it down more, later, if you add more sheets...
=IFERROR(HYPERLINK("#"&INDEX(Sheetnames,ROWS($A$2:A2))&"!A1",INDEX(Sheetnames,ROWS($A$2:A2))),"")

This This will create a list of all sheets, and add a hyperlink to A1 - change that to U6, and create another link to Z6

I'm pretty sure I've done everything as instructed.....

Cheers
Zigi