Auto fill "cell values against each "worksheet name" in Summary Sheet" to a cell location in each worksheet respectively

[husnain]

"I am working on multi worksheets and managed to have a summary sheet that contains the name of each worksheet in column B.
Now i have another column F that contains specific values against all worksheets. I want these values to be auto filled on respective Worksheets in Cell location D3 of each worksheet.
Please help me out."

 

[DRSteele]

This here video might answer your question: https://www.youtube.com/watch?v=cjBEBn6YMi0

And by the way, you can get Excel to actually list all the worksheets in a workbook. Take a gender at these here links:
How do you print a list of Worksheet Names? - Microsoft Community
and
List All worksheets in a Workbook - Microsoft Community