Create links to all sheets in a workbook

I am looking for some code to make a list of links to each sheet in my workbook starting at the 7th tab and going to the end. The result would need to start on the 6th sheet which is named "Summary" in cell A4. I also need it to clear previous entries from A4 down. Any code I have come across list every sheet and I need to exclude the first 6. Any help is greatly appreciated.

Originally Posted by Richard Buttrey

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

I'm not clear exactly what you are looking for. Are you saying that all the sheets after the 6th tab index sheet each contain links to other sheets? e.g. sheet 7 might contain three links to sheet 10, sheet 8 might contain 10 links to sheet 11 and 5 links to sheet 12....etc. and you want a list of all these? If so what do you want to see. The link name, the address to which it links...what?

I attached a before and after file of my workbook. I couldnt create the links myself on the summary page but I made them blue to simulate a link.

Originally Posted by Richard Buttrey

Is the requirement just to list the sheet tab names?

You mentioned links, by which I assumed you meant hyperlinks.

Not just a list......I need the list to be hyperlinks to the sheet. I currently have it set up to make just a list. I need the links

So what I would want to see in column A is a list of the tab names starting at tab 7. And I want that list to be hyperlinks to the tab it references.

Originally Posted by Richard Buttrey

Hi,

See attached.

I also shortened the code in the Summary sheet for populating the formulae in columns B:G

The only issue I had with this hyperlink list is that if I add in a new sheet and run the macro again it doesnt add the new sheet to the list. It still only shows the 3 sheets that were originally in the workbook. I will be adding worksheets through the life of the project so I will need to be able to refresh this list when I add one. Any idea why it is not picking up the new sheet?

Originally Posted by Richard Buttrey

Would you clarify please. The original request was to add hyperlinks to all the pre-existing sheets. That's all I was addressing.

Would you explain what you mean by 'merge' a new sheet. Is that something different to you 'adding' a new sheet.

Upload the workbook and describe exactly the steps you take and which macro you are running.

So this is a fieldbook for construction projects. Each tab is a different work item. All of these projects start out with varying number of work items. I have templates set up for each work item in our catalog and they can be located in a templates folder. When I first create this fieldbook I use Module 7 "Mergeandfillheader" to merge all work items on the data tab into the fieldbook from my templates folder. Throughout the life of the project new work items may be added to the project. When this happens I use Module 1 "MergeExcelFiles" to bring in a template for that work item. So as those changes happen I need to run the "ListAllSHeets" macro that you created to update my summary. I would like the "ListAllSheets" macro to first clear out anything from A:4 down and then make the list of hyperlinks starting at tab 7 and going all the way to the last tab. If I have to add a tab, I would like to be able to run the macro again to make a list from tab 7 all the way to the last tab again. This action would update my summary and include the new tab. I hope this helps and I do appreciate your help. The same workbook I attached before applies.