Copy Master worksheet data to other sheets!

I need to make a macro that basically copies entries from a master worksheet to other worksheets in the same workbook. The entries will be entered into the main worksheet first and then I need a button or hotkey that runs the macro. The entries are to be placed in the appropriate value stream worksheet once I run the macro. I am new to using macros so I'm not sure where to start on this. Thanks for any help.

Columns A thru I are the items that are manually entered and need to be copied. I will need the ability to update as the date due and date completed columns are updated on the master list.

Hello ,

You can create a macro that looks like this

sub tes()
  dim Mastersheets as worksheet
  dim tempMain as worksheet
  dim temp as string
dim cardnumber as string


set Mastersheet = worksheets("Master")
set tempMain = worksheets("Main")

Mastersheet.activate
range("A2").activate

temp= activecell.value
while len(temp)>0 
 if instr(1,temp,"Main")> 0 then
 cardnumber = activecell.offset(0,1).value
 tempmain.activate
 activecell.value= temp
 activecell.offset(0,1).value = cardnumber
activecell.offset(1,0).activate
 mastersheet.activate
 end if   
activecell.offset(1,0).activate
temp=activecell.value
loop

end sub

Hope above macro helps you.