Auto generate sheets using template sheet and upon data entry. Link to main sheet

I am trying to put together a workbook and lost my old scripts and need help rebuilding them with some additional features.

My main sheet in Column A I have titles that I need to create separate sheets, with the title names, based on a template sheet. On each template sheet I have a cell that I need those titles placed in as well.


I need the Main sheet to be interactive, where if i click on a title it goes to that title's specific sheet.


Lastly, I dont know if this is possible but if I ever add another title to the Main sheet in column A I would like it to automatically create a sheet for this title based on the template sheet.

Any and all help would be greatly appreciated. I had scripts for the first two items but not the third and unfortunately I am not sure what happened to the sheet I had them saved in.

How about this ?

Please Login or Register  to view this content.

I was able to figure it out for anyone else looking for something similar to this. The code is below. This auto creates tabs/sheets from a list using a template sheet I had set up and then applies hyperlinks to the names in the list to navigate to those new tabs/sheets. This will not auto generate sheets upon data entry however. I am actually going to attach this macro to a button to generate sheets. It will not duplicate either.

Please Login or Register  to view this content.