Macro to Auto Add Sheet Name to Summary Page In Workbook

Hi Everyone!

I am new here and I have a very basic understanding of macro's so I need lots of help! Thanks in advance

I would like to have a macro created that every time I add a sheet name that contains "Stock_", that sheet name is automatically added to my summary page. Right now, every time I add a sheet with stock details, i have to go to the summary page and manually type in the sheet name so the formulas in the summary page can pick up the relevant information.

I have added a screenshot to show what my summary page looks like:
summary page macro help.jpg

Thanks so much for the quick reply. So i inserted the code into the module component but nothing happened. Then I tried it again and tried to run it to no avail. I am a beginner at using vba, so i may be missing something. Assistance pls

Ok, so I put the module in this workbook and when I add a new sheet the message box pops up asking for the sheet name. Once I add it though like Stock_ (stocksymbol), I get a debug message. I have attached a screen shot of it. I also re did the summary page to take away the merged cells because you said it made you nervous . Hopefully this will help. I have also attached a screen shot of it. Thanks!Revision to summary page .jpgVBA Error Message.jpg

The name of the first page is Profit Distribution Summary

Ok, so I put in the new code and I no longer get an error message, but nothing populates on the summary page when I add the new sheet.... Thanks so much for all of you help

Yup, I have a template that I created and that's what I enter and I name the sheet Stock_(Stock Symbol)

So I attached a sample. Just so you know that the Stock_(stock symbol) is the template I created and anywhere there is something highlighted in green, a value has to be entered. Your awesome. Thanks!!!

Hi! I enabled the macros and tried inserting a new sheet with Stock_(stock symbol) and it still didn't feed to the summary page...

Your quick! Thanks I just stepped away from the computer, as soon as I get back in I am goinh to try it. So excited

Hey! So the names show up in the summary page, but the names start showing up in column Q5 instead of E5, do you think its because I have "stock name" in the columns??? I attached a screenshotStarts in Column Q.jpg

I need the sheet names to populate from E5 to Q5 so the formulas can pick up the right numbers. So I removed the text and formatting entered in those cells so that it can start pooulating from E5, but even with an empty cell, now when I add a sheet with stock_ nothing shows up in the summary page again... HELP

Would it be better to have like a blank sheet in the workbook that has a formula/macro or something that automatically lists all of the worksheets with the name Stock_ and I just have the summary page pick up information from that list. Almost like a table of contents for the sheets that contain the stock information...

Here you go. Thanks

So what I did was I created a separate worksheet called Stock List and changed it in your VBA code so that every time I add a sheet it populates on that sheet instead of the Profit Distribution Summary Sheet and just put in a formula in the Summary page to pick it up!!! Finally we conquered!! Thanks for your help!!!