Macro Button To Distribute Data Dynamically

Hey guys I'm trying to figure out how to write a macro that will take the information of a column and distribute it throughout multiple worksheets. I'm trying to get the data in cell I6 of my summary sheet into cell B51 of the following sheet, and then I7 of the summary sheet into B51 of the sheet following that and so on. I honestly don't know where to start as I am almost completely new to VBA (most of my programming background is in HTML) so any help would be great! I've already got a variable that defines all of the worksheet names called 'shtName' if that helps at all.

sometimes the quickest way is to record a macro, perform the actions (or part of the actions) yourself by hand... stop the macro, then look at the code in the macro... it should show you what you need, from there it's just a matter of simply modifying that code to finish it off.

-tg

I appreciate the advice. I tried it but as far as I can tell the code you get from doing that is no more dynamic than just going through each worksheet and linking the cells (which is what I'm trying to avoid doing).