copy paste to multiple tabs - VBA Excel :c

[kltinaheart]

Guys, I tried for a few hours, but im in over my head.. :c

so I want to fill certain cells on 80 tabs, copying all from the master page.

So on summary page..
While Row 8 = name of tab.. (C8 already has the name of tab2, D8 already has the same name as Tab3)
Copy row 15 values to the Tabs with the same Column/name as seen in its Row 8 titles.

in other words
i want Summary!C15 to be copied to Tab2!A3 because Tab2 has the same name as the title in Summary!C8
I want Summary D15 to go to Tab3!A3 because Tab3 has the same name as the title in Summary!D8

 

[G12]

Let me know if I misunderstand.
Can you select your group of worksheets you want to copy the cell value to. In the Cell of the grouped sheets you can to copy to enter = then click on the cell you want the details copied to. Then hold ctrl while you press enter to push to all worksheets.

Or you could just type in the heading (instead of a link) whilst the sheets are grouped and again use ctrl + enter to add to all.

 

[DanteAmor]

Try this.
Change in the macro "Summary" for the name of your summary sheet

Sub CopyMultipleTabs()
  Dim j As Long, sh As Worksheet, wSheet As String
  j = 3
  Set sh = Sheets("Summary")
  Do While sh.Cells(8, j) <> ""
    wSheet = sh.Cells(8, j).Value
    If Evaluate("ISREF('" & wSheet & "'!A1)") Then
      Sheets(wSheet).Range("A3").Value = sh.Cells(15, j).Value
    End If
    j = j + 1
  Loop
End Sub