little confused. you have validation list in column Y in sheet called "total inforamtion". You select any one of these cells choose one from the list for e.g Y5 and the activecell(Y5) value is "sheet2"--Y5 is the activecell.
you want the whole row of Y6 that is 5th row to copied in sheet2.
If this assumption is correct use this macro
Dim sh As String
With Worksheets("total information")
sh = ActiveCell.Value
.Cells(Rows.Count, "a").End(xlUp).Offset(1, 0).PasteSpecial
Application.CutCopyMode = False