Can I populate multiple sheets with data from one sheet (variable name) is populated?

My VBA copies two sheets depending on the date. For example, sheet 1 is named "Call sheet for (& Date)". Sheet 2 is named ("Schedule for (& Date)". The dates are the same. However, my code creates (Adds) new sheets from an input box asking the new dates to add when the workbook is first created. It might have only one day all the way up to 10 dates (10 days-20 sheets). So, now I would like to add information (such as another event date/audition date/show end date) in three separate cells (columns C6:C8) within the sheet. The first date is the active sheet name "Call Sheet for & Date". SO I need to now input this new information in the active sheet and also populate all the other sheets that have dates in the sheet's names, either "Call Sheet on" or "Schedule for" sheet if they exist. The VBA sheet code needs to be universal in its design because of the variable sheet names and the copy sheet function when creating the workbook. So far this code works but only for one sheet (sheet 8). Does this make sense? Can you rescue me in this abyss?

Formula:

Please Login or Register  to view this content.

And the module that is being called:

Formula:

Please Login or Register  to view this content.

Thank you so much for the reply. Here is the desensitized workbook. The primary purpose for my request is to populate the common data on the sheets after they are created. In an ideal world, the input should take place on the first "Call sheet for mm/dd/yyyy" sheet and then be copied to all others that need this info. I didn't think that an "after" sample was needed but would be happy to do so if you think it might help. Also note, the workbook is used by several folks, hence the need to be as user friendly and automated as possible.

I really cant thank you enough for your time!

Thanks for the forward. I have, perhaps not removed enough of the code to focus on the issue. Still a newbe here.

Thanks for helping with this! I am getting "Run time error 91" with this line:

Please Login or Register  to view this content.

It seems it should work but does not.
Thoughts?

Hi xladept,
No Go. I've tweeked until my brain itches. My thought is that if there was a way to "select" an array of sheets containing ("Call Sheet for" & idate) and just populate those sheets I can always use a formula to copy the data over to the other sheets. For some reason the first position of the "Call Sheet for" (also the active sheet in the workbook) still gives a "run time error 91". Finally because the last sheet contains the oldest date (last position) and is the one that gets copied when it's the first sheet that gets activated (because of the sort and activate code). I am wondering if I need to use an array? You've been so helpful, I do not want to over-extend your kindness. Please let me know if this is the case. I will keep Frankensteining code.