Thanks Brian for looking into. Information in Summary sheet is copy from another file physically. Only column C information is need to copy into appropriate sheet in C3.
OK , assuming that the table and sheets are in the same order and the first name sheet is sheet 3 as per your example simple code as below should work.
Brian
Code:
Dim r As Long ' row index
Dim n As Long ' sheet index
r = 3
n = 3
Do
Worksheets(n).Range("a5") = Worksheets("summary").Cells(r, 3)
r = r + 1
n = n + 1
Loop Until Worksheets("summary").Cells(r, 3) = ""
Thanks Brian. I am getting " Complier Error: Invalid outside prodecure". Not sure where you get sheet 3 from. Also not sure about why A5. Summary sheet contain a two table. Column B, name of the sheets and column C contain appropriate Names which should copy into the Name1 to Name4 in cell c3. Edit my file and re-send please.