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.